topic Re: Above and multiple dimensions problem in QlikView

Above and multiple dimensions problem

ecabanas — Thu, 11 Jul 2013 14:30:43 GMT

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

Re: Above and multiple dimensions problem

Gysbert_Wassenaar — Thu, 11 Jul 2013 14:31:40 GMT

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

above(total Margin)

Re: Above and multiple dimensions problem

ecabanas — Thu, 11 Jul 2013 14:36:24 GMT

Hi Gysbert

I use this and did not works:

Above(TOTAL[MargenCA])

Re: Above and multiple dimensions problem

Gysbert_Wassenaar — Thu, 11 Jul 2013 14:38:46 GMT

Please read these two documents:

Re: Above and multiple dimensions problem

ecabanas — Thu, 11 Jul 2013 15:02:12 GMT

Hy see attached the project, sorry!!!

Re: Above and multiple dimensions problem

Gysbert_Wassenaar — Tue, 23 Jul 2013 14:24:31 GMT

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

Re: Above and multiple dimensions problem

Tue, 13 Aug 2013 13:35:32 GMT

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

Re: Above and multiple dimensions problem

Tue, 17 Sep 2013 14:43:32 GMT

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?

Re: Above and multiple dimensions problem

Mon, 23 Sep 2013 13:31:08 GMT

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