1 Reply Latest reply: Nov 6, 2017 4:03 AM by P M RSS

    Previous Months and Next Months

    wajiha khan

      Hi,

       

      I am new to qlik and facing a little difficulty in making a logic.

      Actually i have two fields coming from two different tables. In both tables some fields are common.

      I want to set an expression for two different dimensions where one dimension (on selection of year and month) shows values of last 6 months from current month and the other dimension (on selection of year and month) shows values of next 3 months from current month. Actually i want to compare the consumption and requirement based on year and month selection.

       

      How could it be possible?

      Please help

      I would really appreciate if someone goes through this and guide me through proper solution.


      Thanks