Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

virtual table of running total?

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

2 Replies
morris70
Valued Contributor

Re: virtual table of running total?

Hi

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?Capture.PNG

Not applicable

Re: virtual table of running total?

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.

Community Browser