This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
Thanks, at the end formula was ok, we have to manage script for a different model capabilities, but running sum expression was ok. 🙂
View solution in original post
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.
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.