Customize subtotals for Dimensions using dimensionality.

Tue, 17 Jul 2012 21:53:54 GMT

Hi all,

I am trying to customize a subtotal for a particular expression at the overall dimension level to be equal to the last weeks total (Each weeks have sequesnces where last week sequence is -1).

Please refer to image below.

At Vendor St dimension level I would like the HIS to be equal to the HIS for week 201225 and for all the other weeks un-changed. I tried using dimensionality with set analysis in expression

if(dimensionality = 1, sum({<Week.Seq = {'-1'}>} HIS), sum(HIS))

This works perfectly for all rows but not the global totals since I get the same value for Week 201225 and the sum but the other weeks are all 0. I understand why this is the case. I just can't seem to find how to solve this issue.

Re: Customize subtotals for Dimensions using dimensionality.

Wed, 18 Jul 2012 15:02:24 GMT

Hi all,

Found the solution.

The expression is as follows:

if(Dimensionality() = 0 AND ColumnNo() <= 1, sum({<Week.Seq = {'-1'}>} HIS), sum(HIS))

All I did is make sure that only column 0 (Total and Last week) are effected.

topic Re: Customize subtotals for Dimensions using dimensionality. in QlikView

Customize subtotals for Dimensions using dimensionality.

Re: Customize subtotals for Dimensions using dimensionality.