Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

thonipad
Not applicable

Top N Rows using Slider

I want to show top N rows using a slider object based on amount field. I tried a simple RANK(AMOUNT) in the expression field & it did not work. Any directions?

Thanks,

Dinesh.

1 Solution

Accepted Solutions
martin59
Not applicable

Re. :Top N Rows using Slider

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

11 Replies
martin59
Not applicable

Re. :Top N Rows using Slider

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

villafuerte
Not applicable

Top N Rows using Slider

Hello,

What you can do is to create a variable linked to the Slider and use it as the Max Number in the Presentation tab, so you only get the first N rows.

Remember to Sort your table so you get the highest (or whatever the ranking is)

Hope it helps!

villafuerte
Not applicable

Top N Rows using Slider

I write too slow haha, sorry. Martin got the answer first.

sathishkumar_go
Not applicable

Top N Rows using Slider

Hi Dinesh

Just create 1 variable and goto slider properties and apply that variable.

then goto chart like (Pivot) give max number shows as that variable.

Hope this will help for you.

-Sathish

thonipad
Not applicable

Re. :Top N Rows using Slider

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.

martin59
Not applicable

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

You have to enter an integer value in your variable.

This value will be modified with your slider.

Martin

thonipad
Not applicable

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

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.

martin59
Not applicable

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

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

thonipad
Not applicable

Top N Rows using Slider

One big problem I see is that the 'Table Box' does not have the 'max numbers' in the presentation tab. Does that mean that we cannot accomplish this in 'Table Box'?

What exactly should be the formula in the variable? Should it be =Rank(FINANCED_AMT)?

Thanks,

Dinesh.