Display last 6 month by selecting a month in filter pane Qlik Sense
I have 24 months data(2018 & 2019), Need to create a pivot table.
Dashboard should display last 3 months data and if i select a month 2019-march, dashboard should display 2019-march,2019-Feb,2019-Jan. If i select 2019-Jan,dashboard should display 2019-Jan,2018-Dec,2018-Nov.
I haven't used max function in date fields, by using max function I am always getting (max month -6) month result. But the issue is by using above expression my pivot table showing result as null, so result will be shown only when selecting a month filter pane.
If need to show something when end user opening dashboard, having two options