Set Analysis With Relative Selection

Tue, 18 Apr 2017 08:43:58 GMT

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,

Re: Set Analysis With Relative Selection

Tue, 18 Apr 2017 09:29:19 GMT

I think I've got the solution :

Sum({<Date_Chopin = {">=$(=date(Addmonths(MoisAbaque,-1),'YYYYMM'))<=$(=date(Addmonths(MoisAbaque,+1),'YYYYMM'))"} >} mynum)

It works.