1 Reply Latest reply: Apr 18, 2017 5:29 AM by Rozenn HAMON RSS

    Set Analysis With Relative Selection

    Rozenn HAMON

      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,