Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to create an expression with set analysis based on another time dimension selection?
any ideas ?
MoisAbaque is my selection.
I Want to sum for MoisAbaque, MoisAbaque + 1 and MoisAbaque -1
Something like That :
Sum({$<Date_Chopin=MoisAbaque
OR Date_Chopin=date(addMonths(MoisAbaque,-1),'YYYYMM')
OR Date_Chopin=date(addMonths(MoisAbaque,+1),'YYYYMM')
>} mynum)
Date_Chopin and MoisAbaque are Date format YYYYMM
I'am using Qlik Sense
Thank You for help,
I think I've got the solution :
Sum({<Date_Chopin = {">=$(=date(Addmonths(MoisAbaque,-1),'YYYYMM'))<=$(=date(Addmonths(MoisAbaque,+1),'YYYYMM'))"} >} mynum)
It works.