Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator II
Creator II

How to use condition on Concat function

Hi there ,

I have a condition like I have six value having top record coming from expression -

=Concat(DISTINCT Aggr(If(Sum({<DepartureDate.last_n_days={">=0<=27"}>}[ETP Denominator]-[ETP Numerator]) = Max(TOTAL Aggr(Sum({<DepartureDate.last_n_days={">=0<=27"}>}[ETP Denominator]-[ETP Numerator]), [Arrival Hour]), 1), [Arrival Hour]), [Arrival Hour]), ', ')

 

My req is : how to show 10,17 etc when value is more than 2 , else show 10,17..

The value is showing in chart text

ashmitp869_0-1657521902914.png

 

Labels (2)
1 Reply