Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

TOP N LOAD * INLINE

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!

1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

Try with

=Alt(TopValues,Count(DimensionField))

View solution in original post

8 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

HI Michael,

please Find attachment It will help you.

Just modify Variable value to your Inline table value.

Thanks,

Arvind Patil

stigchel
Partner - Master
Partner - Master

Try with

=Alt(TopValues,Count(DimensionField))

ahaahaaha
Partner - Master
Partner - Master

Hi,

Which object Qlik Sense are you using for selection of TopValues?

Anonymous
Not applicable
Author

May be i didn't looked at the right place... found only variable and id.. not the expration

but thank u!

Anonymous
Not applicable
Author

Field UI

Anonymous
Not applicable
Author

Thank you very much!! It working!

Alt is Alternative?

stigchel
Partner - Master
Partner - Master

You're welcome. From the help

alt - script and chart function

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.

alt ‒ QlikView

Anonymous
Not applicable
Author

Thank you very much!