Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
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
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
Partner Ambassador
Partner Ambassador

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
Partner Ambassador
Partner Ambassador

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

Anonymous
Not applicable
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

Anonymous
Not applicable
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

Anonymous
Not applicable
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.