How to use condition on Concat function

ashmitp869 — Mon, 11 Jul 2022 06:46:40 GMT

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

topic How to use condition on Concat function in QlikView

How to use condition on Concat function

Re: How to use condition on Concat function