topic Re: Cumulative Ratio in QlikView

Cumulative Ratio

Tue, 11 Dec 2012 20:48:00 GMT

I just want to find the best way to answer this issue.

Suppose I have a file with

- MonthName (Jan12, Feb12, ...)

- A a numeric field

- B a numeric field

I want to display in line chart, the evolution of the Ratio = A/B with accumulation

So for example, in june my ratio should be sum( A) from Jan to June / sum(B) from Jan to June

Usually I create a calendar which allow me to compare the monthname in the calendar with the monthname in the data.

It works but i'm sure is the solution.

Any idea ?

vgutkovsky — Tue, 11 Dec 2012 20:59:32 GMT

How about something like the attached?

Regards,

Vlad

Wed, 12 Dec 2012 08:32:46 GMT

Hi Vlad

Not exactly, because I don't want to display the numerator and the denominator, but just the cumulative ratio.

If I use

rangesum( sum(A),above(sum(A)) ) / rangesum(sum(B),above(sum(B)))

The calculation gives only the ratio for the current & previous rows.

Maybe someyhing with noofrow()

vgutkovsky — Wed, 12 Dec 2012 13:05:36 GMT

And your object cannot be a straight table (where expressions can be hidden)? Or a graphical chart (where expressions can be set to "Invisible")?

Vlad

Thu, 13 Dec 2012 11:53:14 GMT

Not really

Finally, if find a good way with

=rangesum( above(sum(A) , 0 , noofrows() ) )

rangesum( above(sum(B) , 0 , noofrows() ) )

Thanks anyway

vgutkovsky — Thu, 13 Dec 2012 13:12:03 GMT

I'm not sure what your function does, but glad you got it working.