topic Multiple 'Set Variable' in actions in QlikView

Multiple 'Set Variable' in actions

Tue, 16 Feb 2016 13:06:57 GMT

I do a pareto analysis on the Sales value (80%) of the top x customers.

The problem is the following:

I want to show how many of how many customers make up the 80% sales. eg:.(49 of 728 customers selected (6.7%)

My approach was:

In the actions tab of the button;

- set variable vCntCustomers = count (distinct Customers)

- Pareto Select

- set variable vCnt CustomerSelected = count (distinct Customers)

(to store the number of customers before the pareto)

I learned this does not work because all variables are set at the same time.

I cannot use "all" because the pareto has to work within a selection made by the user.

What would be a better approach to achive this

Thank you

swuehl — Tue, 16 Feb 2016 14:23:35 GMT

You can try an approach as shown here:

Very similar to your approach, but using an alternate state for the pareto select.

Then the count percentage calculation would be

= Count({AlternateState} DISTINCT Customer) / Count({$} DISTINCT Customer)

Tue, 16 Feb 2016 14:45:33 GMT

Thank you for your quick response

It solved my problem 🙂