Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
How to achieve this.
Dimension:
Product
S_date
Metric:
Revenue
Thanks in advance 🙂
In my expression change today() to max(date)
Hi,
Try by using below expressions
Dimension:
Product
Measure:
Sum ({< YearMonth= {">=$(=Date (AddMonths (Date (YearMonth,'YYYY-MMM'),-5),'YYYY-MMM')) <=$(=Date (YearMonth,'YYYY-MMM'))”}>} Revenue)
Column Condition:
aggr(only({<YearMonth={">=$(=date(monthstart(addmonths(YearMonth,-5)),'YYYY-MMM'))<=$(=date(YearMonth,'YYYY-MMM'))"}>}YearMonth),[YearMonth])
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
1) Setting default bookmark - https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Bookmarks/set-defaul...
2) Always one selected value - https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/DataSource/select-si...