Chart not ignoring specified dimension

[#1]

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.

[sunny_talwar]

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%))