topic Re: Re: Ratio between two dimensions in QlikView

Ratio between two dimensions

mys-elf — Fri, 25 Apr 2014 09:02:50 GMT

Hi All,

I want to generate a matrix which shows me the ratio between two dimensions.

First I calculate the revenue by a set analysis. This revenue belongs to the selling profitcenter and also to the profitcenter where the buying customer is allocated.

Every customer is allowed to buy in every profitcenter he wants to and I want to see the ratio between the allocation and the actual distribution of revenues.

It's esy to calculate absolute values (picture/left) but I got some trouble in finding a working formula for the ratio between those two dimensions (picture/right). I think it has to be the AGGR-function but I don't know how to use it the right way.

Thanks in advance!

Re: Ratio between two dimensions

Gysbert_Wassenaar — Fri, 25 Apr 2014 11:50:27 GMT

Generally you want something like sum(Value)/sum(TOTAL Value). Since you didn't post any information about your expression other then that there's an aggr in it somewhere I can't give you a better answer.

Re: Ratio between two dimensions

mys-elf — Fri, 25 Apr 2014 12:14:57 GMT

Ok, that's my formula for the absolut value:

sum({$<t.stat.type={2}>}t.stat.revenue)

And I want something like for the ratio between two dimensions:

sum({$<t.stat.type={2}>}t.stat.revenue) -- 'dimension a'

sum({$<t.stat.type={2}>}t.stat.revenue) -- 'dimension b'

Re: Ratio between two dimensions

jolivares — Fri, 25 Apr 2014 12:33:39 GMT

In this case you can use functions like above/below see in the help how use it them.

Re: Re: Ratio between two dimensions

Fri, 25 Apr 2014 12:59:23 GMT

Matthias,

i understand, that customer allocation and selling profitcenter are you two dimensions.

Look for my example.

Re: Re: Ratio between two dimensions

mys-elf — Mon, 28 Apr 2014 07:08:45 GMT

Thank you so much Dariusz!!!