topic Re: Dynamic selection for top N records in QlikView

Dynamic selection for top N records

sonysree88 — Sat, 16 Nov 2024 04:38:59 GMT

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

Re: Dynamic selection for top N records

uacg0009 — Mon, 28 Jan 2019 06:40:35 GMT

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

Re: Dynamic selection for top N records

Anil_Babu_Samineni — Mon, 28 Jan 2019 06:43:31 GMT

Can you please little more? Perhaps this

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

Re: Dynamic selection for top N records

sonysree88 — Mon, 28 Jan 2019 06:45:43 GMT

I want to use Straight table here

Re: Dynamic selection for top N records

sonysree88 — Mon, 28 Jan 2019 06:46:41 GMT

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

Re: Dynamic selection for top N records

bvssudhakar — Mon, 28 Jan 2019 08:16:02 GMT

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

Re: Dynamic selection for top N records

sonysree88 — Mon, 28 Jan 2019 08:24:36 GMT

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

Re: Dynamic selection for top N records

bvssudhakar — Mon, 28 Jan 2019 09:26:49 GMT

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