Dynamic Button to Select Top n Values

[#1]

Hi,

I want to have a button that when pressed selects the top n values of a field but I also would really like a user to be able to input how many values and which of the fields (Cost, Revenue, Margin) it selects over.

In the button options I have tried 'Select in Field' but don't know what to put for the Search String. I also don't know how to incorporate inputs into a buttons functionality.

Any help would be much appreciated!

[danielrozental]

Can't you just use a straight table, you can set how many rows are seen by changing "max number" in the presentation tab, you can use a variable to set that.

[danielrozental]

If the above doesn't help you can try something like this

="=rank(aggr(sum(Sales),Customer))<=" & variableN

[#4]

I could have a separate table where users could select the contents but I'd rather have a shiny button on each page of graphs that selects the best and worst. I tried =rank(aggr(sum(Cost), Customer))<=10 in the search string but it doesn't seem to do anything.

[gandalfgray]

You could use Input Field to set a variable (vLimit in my example).

Use that variable in the Presentation->Max Number setting of your chart.

[lironbaram]

hei

attach is an example

maybe it can help you

what the user will have to do is select the measure for filter

number of top Customers

and the table will filter

[#7]

I only have personal edition so can't open other people's files. Is it possible for you to explain what you've done with some code?

Thanks!

[lironbaram]

ok let try

attach is an excel file which is my sorce data

my script looks like this:

Data:

LOAD CustomerID,
CustomerName,
Sales,
Cost,
Profit
FROM

(ooxml, embedded labels, table is גיליון1);

LOAD * INLINE [
Meas
sum(Sales)
sum(Cost)
sum(Profit)
];

then i have this objects in the appliction:

list box of the filed Meas

input box for a Varaible with the name vNum

Chart of Stright Table with

dimension: =aggr(if(rank($(=only(Meas)) )<=vNum,CustomerName),CustomerName)

with the box: Supress when null is values - Checked

expressions:

sum(sales)

sum(profit)

sum(cost)

try to bulid a qvw file like that and then follow what i wrote in the previous post

[SunilChauhan]

hello ,

Take i inline like below

Load * Inline [

ColName

Top1

Top2

Top3

:

:

:

:

Top N

];

in chart u want n max

go to presentation and in max number shown  option write code below

If(ColName='Top1',1,if(ColName='Top2',2,...........))

hope it will work for you

thanks

Sunil Chauhan

[#10]

You can use a Slider control to let the user select a value into a variable.  Then in the Presentation tab, in the Max visible number, reference the variable used in the Slider control.