Dynamic selection for top N records

[sonysree88]

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

[uacg0009]

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

[Anil_Babu_Samineni]

Can you please little more? Perhaps this

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

[sonysree88]

I want to use Straight table here

[sonysree88]

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

[bvssudhakar]

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]

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 · Accepted solution]

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