topic Re: virtual table of running total? in Qlik Learning Discussions

virtual table of running total?

Tue, 16 Dec 2014 20:51:04 GMT

I have a straight table with Person as a dimension and several expressions. I would like to add a new expression that computes "% of Clients making up 80% of Revenue"). Is this possible? Person, Client, Revenue are the applicable fields.

To do this manually, I would sort each Person's Client list in descending order by Revenue, create a running sum, divide by Person's total revenue, and count until >=80%. Seems like I need multiple aggrs for this to work, but I can't get close...thanks

Re: virtual table of running total?

Anonymous — Tue, 16 Dec 2014 21:52:21 GMT

Have you tried looking at dimension limits?

Also there is an example in the "What's New In QlikView 11" demo app.

Is this similar to what you want?

Re: virtual table of running total?

Tue, 16 Dec 2014 21:56:41 GMT

thanks for the reply ... in the examples you give, the sum of the rows gets the 80%. In my example, I want to compute the 80% threshold for EACH row. Make sense?

Output would look like:

Dimension ... Expression

A...4

B...5

C...6

Where 4, 5 and 6 = number of Clients making up 80% of Revenue for that Person.