topic Re: Pivot table Above or Range sum issue in QlikView

Pivot table Above or Range sum issue

Thu, 02 Apr 2015 06:37:26 GMT

Dear Gurus,

As per the attached document i need to get Range sum, which is wokring fine in Table1 but when user moves the dimension to horizontal

"above" function does not work. do we have any other function to achive Range sum when dimension is horizontal, thanks in advance

Gysbert_Wassenaar — Thu, 02 Apr 2015 06:58:21 GMT

Yes, the before() function should do the trick. And replace RowNo() with ColumnNo().

Thu, 02 Apr 2015 07:03:33 GMT

Hi Gysbert, thanks for quick reply but unfortunately Before does not work ...

jagan — Thu, 02 Apr 2015 07:15:22 GMT

Hi,

Try this expression

sum(Exp)

Before(sum(Exp))

RangeSum(Before(sum(Exp),0,ColumnNo()))

Regards,

Jagan.

Gysbert_Wassenaar — Thu, 02 Apr 2015 07:17:37 GMT

That's very strange. It seems to work for me. See attached qvw.

Thu, 02 Apr 2015 07:55:51 GMT

Thansk a lot Jagan and Gysbert