Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Previous Months and Next Months

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

1 Reply