topic Top N Rows using Slider in QlikView

Re. :Top N Rows using Slider

martin59 — Wed, 05 May 2010 15:59:33 GMT

Hi Dinesh,

You must create a variable which contain the number of lines to show.

Use this variable in your slider and in your graph with the option : Max number...

Martin

Re. :Top N Rows using Slider

Anonymous — Wed, 05 May 2010 16:19:52 GMT

OK. This is the first time I am creating a variable. I clicked on Settings, 'Document Properties' & selected the Variable tab. I clicked on 'New' button & added a variable called 'Rank' & in the Value settings, I put in the formula =rank(FINANCED_AMT). Then I went to the slider & selected the newly created variable 'Rank' & the slider is empty. What am I doing wrong? Please be patient with me as this is my first report creation.

Thanks,

Dinesh.

Re. :Re: Re. :Top N Rows using Slider

martin59 — Wed, 05 May 2010 16:24:16 GMT

You have to enter an integer value in your variable.

This value will be modified with your slider.

Martin

Re. :Re: Re. :Top N Rows using Slider

Anonymous — Wed, 05 May 2010 16:35:22 GMT

O was not clear in my original post. I have one table view & many chart views in my dashboard. I want all the different view change based on my selection of Top N rows in the slider.

I changed the value of the variable to 1 (integer value), but that did not help. I selected the min & max values as suggested, but that gives me a static slider from my min to max range & does not change anything on my tables & charts.

Where do I define that this is a filter for Top N rows based on the amount of the row?

Thanks,

Dinesh.

Re. :Re: Re. :Top N Rows using Slider

martin59 — Wed, 05 May 2010 19:39:51 GMT

You define that in the presentation tab of your charts & tables.

Enter the name of your variable into the expression editor of this option.

Send your application for more efficiency.

Martin

Re. :Re: Top N Rows using Slider

martin59 — Wed, 05 May 2010 21:00:29 GMT

The Table Box shows your datas with the associations between fields. It's a representation of your datas, no expression, no max numbers, etc...

If you want to simulate a table box, you can do a straight table with an expression like rank(FINANCED_AMT) or 1 basically.

Your rank expression must be in your charts et desc-sorted to filter on the best dimensions.

Martin

Re. :Re: Top N Rows using Slider

Anonymous — Fri, 07 May 2010 13:49:53 GMT

Thanks everyone for your answers. Really appreciate it.

Dinesh.