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 :


      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,