topic Re: select % from running Total in QlikView

select % from running Total

andreip21 — Wed, 25 Nov 2020 16:16:04 GMT

Hello all,

I want to automatically select some product_ids based on their cummulated % in Total Sales generated.

For example, if i want 80% (i will create a input in my script and a slider in the interface), the first 6 Product IDs will be selected.

If i want 50%, only the first two.

It will help me than to calculate a conversion rate only for the selected products.

How do i do that?

Product ID	Sales	Running Total%
1	500	27.5%
2	400	49.6%
3	200	60.6%
4	150	68.9%
5	120	75.5%
6	100	81.0%
7	80	85.4%
8	75	89.5%
9	70	93.4%
10	60	96.7%
11	40	98.9%
12	20	100.0%

Re: select % from running Total

shiveshsingh — Wed, 11 Apr 2018 10:26:31 GMT

Make a variable ..as vTest and then set action on button to select value with search string ='>='& $(vTest)

one inputbox also to define value for vTest

Re: select % from running Total

shiveshsingh — Wed, 11 Apr 2018 10:28:26 GMT

small example

Re: select % from running Total

sunny_talwar — Wed, 11 Apr 2018 11:14:04 GMT

I think what you need is to look here

Recipe for a Pareto Analysis – Revisited

Re: select % from running Total

andreip21 — Wed, 11 Apr 2018 11:59:55 GMT

ok, but i need to select products, so select in field with Field = Product ID

and vTest need to be a % from Total Sales.

How do i do that?

Re: select % from running Total

andreip21 — Wed, 11 Apr 2018 12:01:21 GMT

yeah, great article, but the expression doesn't work in my case because i have a 1GB QVW and any aggr in the interface is veeery slow.

Re: select % from running Total

sunny_talwar — Wed, 11 Apr 2018 12:04:34 GMT

Can you pre-aggregate everything at the script level? That is the only other solution... but then you loose the dynamic nature of QlikView where the pareto change based on selections.