Top N Rows using Slider

[Anonymous]

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.

[martin59 · Accepted solution]

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]

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]

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

[sathishkumar_go]

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]

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]

You have to enter an integer value in your variable.

This value will be modified with your slider.

Martin

[Anonymous]

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]

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]

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.