topic Re: Running sum of average in QlikView

Running sum of average

canmarroig — Thu, 03 Jan 2019 12:37:56 GMT

I need to create a waterfall graph, i've 3 different products i must forecast value depending on five different variable, my expression must be a running sum of avg :

if(RowNo()=1 or RowNo()=count(Dimension)+1,0,RangeSum(Above(avg(Value),1,RowNo()-1)))

but i wonder if my approach is ok, can you help me? Here attached a simplfied model of my dashboard.

Tks!

Re: Running sum of average

sunny_talwar — Fri, 04 Jan 2019 12:45:46 GMT

Is the output not what you expect? I mean why do you have doubts?

Re: Running sum of average

canmarroig — Fri, 04 Jan 2019 15:10:44 GMT

I'm producing my dashboard from Tableau to Qv, the function RUNNING_SUM(AVG([value])) elaborates data in a different way, in QV every level up or down my value doesn't change meanwhile Tableau generate a different distribution of data.

Re: Running sum of average

sunny_talwar — Fri, 04 Jan 2019 15:26:33 GMT

Have not really used Tableau to know what the expression you gave might do... but if you can share the expected output for each bar in numerical terms, I might be able to take a look at it.

Re: Running sum of average

canmarroig — Wed, 23 Jan 2019 09:50:36 GMT

Thanks, at the end formula was ok, we have to manage script for a different model capabilities, but running sum expression was ok. 🙂