Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set analysis ignore current dimension value

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

 

DimensionExpression
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)
2 Replies
sunny_talwar

Should be something like this

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

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.