topic Selecting top 3 values in QlikView

Selecting top 3 values

rohitians — Fri, 28 Jun 2013 11:35:42 GMT

Hello,

I have this pivot chart where in I have a cyclical drill which has compny , therapies as dimensions which has many brands with sales values,

Now there are many brands i only want to show number of brands the user wants or selects in the input box....

Is this possible...

Thanks and Regards,

Rohit

Fri, 28 Jun 2013 11:43:08 GMT

take straight table--presentation tab--> check the dropdown select after select field

anandathome — Fri, 28 Jun 2013 11:52:27 GMT

1. Add a list box for brands on the sheet.

2. Select the brands you don't want to show.

3. Right click on the list box and "Select Excluded"

4. Lock the selections.

rohitians — Mon, 01 Jul 2013 05:09:08 GMT

Hello,

I have this pivot table where in i have Companies with their brand names ,I am diplaying sales of this brands CYvsLY..

Now the scene is i want to show only a particular number of brands i.e input box the user may select i want to see only top 3 brands of all companies

so as per the number only 3 top selling brands should be displayed for each company and total sales for that company should be dispayed...

I am attaching a sample qvw file in order to get an idea of the report...

and is it possible to achieve the same...

Thanks and Regards,

Rohit

tresB — Mon, 01 Jul 2013 05:30:27 GMT

PFA. Hope this helps.

Thanks.