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?
I would really appreciate if someone goes through this and guide me through proper solution.