Chart not ignoring specified dimension

Mon, 27 Jun 2016 12:21:03 GMT

Hi all.. I'm experienced in using charts where the set analysis specifies a dimension in order for selections to have no effect on the chart.

The problem I'm having now is where the chart is NOT ignoring the dimension I specify for it to ignore ([Fiscal Period]).

The chart uses only one dimension called [Fiscal Month Name].

There is one expression:

sum( {<[Statutory classification]={'Asset'},

[Fiscal Year]={$(vMaxFiscalYear)},

FiscalYearMonth={">=$(vMaxYearMonth-13)<=$(vMaxYearMonth)"},

[Fiscal Period]=,

[Fiscal Month Name]= >}

Balance * if(isnull(Explosion%),1,Explosion%))

Variables defined:

vMaxFiscalYear = max({<[Fiscal Period]>}[Fiscal Year])

vMaxYearMonth =max({<FullDate={"<=$(=today())"},[Fiscal Period]=>}FiscalYearMonth)

vMaxYearMonth-13 = date(addmonths(date#($(vMaxYearMonth)&'01','YYYYMMDD'),-12),'YYYYMM')

As you can see, I also ignore the dimension in set analysis used in the variable definitions.

Has anyone got any idea why this is happening? I've even tried installing a newer version of Qlikview. I'm now on version 12.0.20200.0 SR3 64bit.

Re: Chart not ignoring specified dimension

sunny_talwar — Mon, 27 Jun 2016 13:48:57 GMT

Only place I see where you might not be ignoring the dimension is this:

if(isnull(Explosion%),1,Explosion%)

Can you try this:

If(IsNull(Only({<[Fiscal Period]>}Explosion%)),1, Only({<[Fiscal Period]>}Explosion%))