Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
thonipad
Creator III
Creator III

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
Specialist II
Specialist II

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

View solution in original post

11 Replies
martin59
Specialist II
Specialist II

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
Luminary Alumni
Luminary Alumni

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
Luminary Alumni
Luminary Alumni

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

sathishkumar_go
Partner - Specialist
Partner - Specialist

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
Creator III
Creator III
Author

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
Specialist II
Specialist II

You have to enter an integer value in your variable.

This value will be modified with your slider.

Martin

thonipad
Creator III
Creator III
Author

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
Specialist II
Specialist II

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
Creator III
Creator III
Author

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.