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: 
sonysree88
Creator II
Creator II

Dynamic selection for top N records

Hi Team,

I need Dynamic selection to get top N records either 5 or 10 or what ever its may select in the dropdown or give manually , we should have to reflect in that chart.

Can we use Input Field to set a variable (vLimit in my example).

Use that variable in the Presentation->Max Number setting of your chart.

What is the expression need to write on that Vlimit varible and how to take that in the input variable

 

 

maxnum.JPG

Labels (1)
1 Solution

Accepted Solutions
bvssudhakar
Creator III
Creator III

Hi Sony,

Go to settings tab >> Variable Overview  there you create vLimit Expression

settings tab >> Variable Overview >> Click on Add button >> give that vLimit for variable name Click on OK >> then select that vLimit variable and give number ((whatever you want eg:5) ) in that definition box 

 

 

View solution in original post

7 Replies
uacg0009
Partner - Specialist
Partner - Specialist

Hi,
What kind of chart do you use?
Aiolos Zhao
Anil_Babu_Samineni

Can you please little more? Perhaps this

Sum({<F1 = {"<=vLimit"}>} F1)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sonysree88
Creator II
Creator II
Author

I want to use Straight table here

sonysree88
Creator II
Creator II
Author

What we have to write the expression in the vLimit, Please explain

bvssudhakar
Creator III
Creator III

Hi,

 

Please share your expression. I will modify that expression

 

Please close the threads by marking the correct answer because you are posting questions continuously but you are not closing those threads 

 

Thanks & Regards

B V S Sudhakar

sonysree88
Creator II
Creator II
Author

If i can get the answer i will close it accordingly. I have already closed 2 threads.

Please modify this expression

what needs to be write in Vlimit variable which is given in the above conversion

Sum({<F1 = {"<=vLimit"}>} F1)

Result is : if i can select TOP 5 that top5 records needs to be displayed in the chart , if i can select the limit as 10, TOP 10 records must display in chart

 

Regards,

Sonysree

bvssudhakar
Creator III
Creator III

Hi Sony,

Go to settings tab >> Variable Overview  there you create vLimit Expression

settings tab >> Variable Overview >> Click on Add button >> give that vLimit for variable name Click on OK >> then select that vLimit variable and give number ((whatever you want eg:5) ) in that definition box