Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm trying to create top 10, 20, 50 selection by
LOAD * INLINE [
TopValues
10
20
50
];
and setting in Limitation --> fixed number --> top --> =TopValues
Works fine for 10,20,50... and now how do I get all data? Without selection in TopValues I get TOP 1...
Thank you!
HI Michael,
please Find attachment It will help you.
Just modify Variable value to your Inline table value.
Thanks,
Arvind Patil
Try with
=Alt(TopValues,Count(DimensionField))
Hi,
Which object Qlik Sense are you using for selection of TopValues?
May be i didn't looked at the right place... found only variable and id.. not the expration
but thank u!
Field UI
Thank you very much!! It working!
Alt is Alternative?
You're welcome. From the help
The alt function returns the first of the parameters that has a valid number representation. If no such match is found, the last parameter will be returned. Any number of parameters can be used.
Syntax:
alt(case1[ , case2 , case3 , ...] , else)
The alt function is often used with number or date interpretation functions. This way, QlikView can test different date formats in a prioritized order. It can also be used to handle NULL values in numerical expressions.
Thank you very much!