Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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