Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator II
Creator II

Re: Dynamic selection for top N records

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
Highlighted
Partner
Partner

Re: Dynamic selection for top N records

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

Re: Dynamic selection for top N records

Can you please little more? Perhaps this

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

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)
Highlighted
Creator II
Creator II

Re: Dynamic selection for top N records

I want to use Straight table here

Highlighted
Creator II
Creator II

Re: Dynamic selection for top N records

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

Highlighted
Creator II
Creator II

Re: Dynamic selection for top N records

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

Highlighted
Creator II
Creator II

Re: Dynamic selection for top N records

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

Highlighted
Creator II
Creator II

Re: Dynamic selection for top N records

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