Set analysis ignore current dimension value

Anonymous — Fri, 25 Oct 2019 13:57:27 GMT

How can I ignore dimension values of 201801 to 201806 and show the average sales for 201401 to 201712 and from 201807 show the corresponding months average sales

Dimension	Expression
if(Vintage>=201801,Vintage)
201801	= Avg({Vintage={'>201401<=201712'}}sales)
201802	= Avg({Vintage={'>201401<=201712'}}sales)
201803	= Avg({Vintage={'>201401<=201712'}}sales)
201804	= Avg({Vintage={'>201401<=201712'}}sales)
201805	= Avg({Vintage={'>201401<=201712'}}sales)
201806	= Avg({Vintage={'>201401<=201712'}}sales)
201807	= Avg({Vintage={'=201807'}sales)
201808	= Avg({Vintage={'=201808'}sales)
201809	= Avg({Vintage={'=201809'}sales)
201810	= Avg({Vintage={'=201810'}sales)
201811	= Avg({Vintage={'=201811'}sales)
201812	= Avg({Vintage={'=201812'}sales)
201901	= Avg({Vintage={'=201901'}sales)
201902	= Avg({Vintage={'=201902'}sales)
201903	= Avg({Vintage={'=201903'}sales)
201904	= Avg({Vintage={'=201904'}sales)
201905	= Avg({Vintage={'=201905'}sales)
201906	= Avg({Vintage={'=201906'}sales)
201907	= Avg({Vintage={'=201907'}sales)
201908	= Avg({Vintage={'=201908'}sales)
201909	= Avg({Vintage={'=201909'}sales)

Re: Set analysis ignore current dimension value

sunny_talwar — Fri, 25 Oct 2019 14:43:04 GMT

Should be something like this

If(Vintage >= 201806, Sum(Measure), Avg({<SetAnalysisRange>} TOTAL Aggr(Sum(Measure), Vintage)) )

Re: Set analysis ignore current dimension value

Brett_Bleess — Mon, 04 Nov 2019 22:15:17 GMT

Siva, did Sunny's post get things working for you? If so, please be sure to return to the thread and use the Accept as Solution button on his post to give him credit for the help and let others know it worked. If you are still working on things, leave an update.

Regards,
Brett

topic Set analysis ignore current dimension value in QlikView

Set analysis ignore current dimension value

Re: Set analysis ignore current dimension value

Re: Set analysis ignore current dimension value