topic Re: A cumulative expression in QlikView

A cumulative expression

Wed, 15 Oct 2014 12:30:08 GMT

Hello everyone I need a little bit of help.

I have a the below chart that compares the successes and rejections when someone arrives. I want to add an expression that gives me the % rejection of the cumulative values. For example, if I am looking at the week of October 12th I want it to divide 498/(498+3942)= 11.2%, then if I look at the week of October 19th it divides the cummulatives 526/(526+4014)=11.59%. I know it has to deal with a rangesum, but I cant come up with the correct formula. Any help would be much appreciated!

Re: A cumulative expression

johanlindell — Wed, 15 Oct 2014 12:42:40 GMT

You can use the Above/Below and/or Previous/Next functions to read the result from previous value. Something like

[Current Value] / ([Current Value] / Above([Aggregated Value])).

If you change you "chart" to a table and make a column you can test which function gives the the right result. Depends a bit on how your dimensions are set up (if you have more than one).

//Johan

Re: A cumulative expression

mr_novice — Wed, 15 Oct 2014 18:19:32 GMT

Hi Daniel,

Hope this helps: http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/12/accumulative-sums