Above and multiple dimensions problem

[ecabanas]

Hi every one,

I have a sales table with month, family dimensions and sum of sales and margin as an expression. I want to do a calculation with the previous month using above, but If I use two dimensions the above calculation did not work.

sales: sum(sales)

Margin: sales-Cost

previous margin month: Above(Margin)

thank's

[Gysbert_Wassenaar]

If you use two dimensions the above function needs the total keyword to cross dimension boundaries:

above(total Margin)

[ecabanas]

Hi Gysbert

I use this and did not works:

Above(TOTAL[MargenCA])

[Gysbert_Wassenaar]

Please read these two documents:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling.

[ecabanas]

Hy see attached the project, sorry!!!

[Gysbert_Wassenaar]

Sorry for the late response. If I understand you correctly then above(total $(VMargenCA%)) should work. See attached qvw.

[#7]

Hi Gysbert,

So I have a similar issue: I have two dimensions and a rangesum(above ...) expression. I use the TOTAL statement so that it takes care of the multiple dimension problem.

I get the pivot table to work as wanted and the figures are correct!

Now to my problem: I want to display the output in a line-chart, in fact convert the pivot to a line chart to rather disply it graphically as two lines plotted, one for each dimension (in my case plotted on time dimension, and the time dimension must be the first sorted dimension).

I do not get this to work ....... Do you have any suggestions??

Thank you!

David

[#8]

I have ended up having a similar issue. My expressions return correct values when used in a straight table, but if I change the type to line chart it just doesn't work anymore. This is especially an issue with above() function and I haven't figured out what is going on. Did you solve your issue?

[#9]

Hi Henry,

I managed to solve it (with the help of Gysbert, thanks!) by using "accumulate steps back", in my case 99 steps back. This way I do not depend on the rangesum(), function and the line chart displays the correct values. So just rewrite your expression without using rangesum and accumulate it instead. Hope it helps!

BR,

David