Discussion Board for collaboration related to QlikView App Development.
I need your helps as usual
I have a table that contains a measure count (case) and field details, I wanna display the TOP 20 detail according to their count (case) and whene two details have the same count(case) display only the first :
the measure count (case)
You want over top 20 or top 20 per type cas?
Top 20 details according to their count case
add the calculated dimension for details like below
May be like this
=If(Num(Num#(Rank(Count(Case), 0, 2))) < 21, Count(Case))