topic Re: Use the RangeSum and Before function in the Pivot Table in QlikView

Use the RangeSum and Before function in the Pivot Table

Wed, 15 Jan 2014 12:39:04 GMT

Hello~!

I would like to calculate the MTD figure using the rangesum and before function in the pivot table, it's OK if there is only one dimension in the pivot table, but the result isn't my expectation when there are two dimension, please refer as below and the attached file. Thanks a lot.

Re: Use the RangeSum and Before function in the Pivot Table

Clever_Anjos — Wed, 15 Jan 2014 12:45:37 GMT

What is the expected?

Re: Use the RangeSum and Before function in the Pivot Table

kiranmanoharrode — Wed, 15 Jan 2014 12:47:20 GMT

Dear WU,

It wont't work on PIVOT TABLE,

It is restricted for Straight table.

Regards

Kiran Rode

91 8976977897

Re: Use the RangeSum and Before function in the Pivot Table

danieloberbilli — Wed, 15 Jan 2014 13:08:18 GMT

If you delete the day from the dimension you get the right values.

Note the following limitation:

If the pivot table has multiple horizontal dimensions, the current row segment will include only columns with the same values as the current column (which is your month) in all dimension rows except for the row showing the last horizontal dimension of the inter field sort order (which would be your Week). The inter field sort order for horizontal dimensions in pivot tables is defined simply by the order of the dimensions from top to bottom.

Re: Use the RangeSum and Before function in the Pivot Table

jonathandienst — Wed, 15 Jan 2014 14:51:10 GMT

You need a TOTAL in the Before(). See updated qvw attached.

HTH

Jonathan

Re: Use the RangeSum and Before function in the Pivot Table

deepakqlikview_123 — Wed, 30 Apr 2014 08:53:12 GMT

Hi Jonathan,

Can you pleasetell me how expression

=RangeSum(Alt(Before([Count YTD]), 0), sum(Count)) will work.

Thanks