Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik,
I've a requirement to show only 18month data from current month. Actually I've future dates till 2028.
At any time my dashboad should show 18month from current month data. For now we are showing till current year data which I need to change.
Current Script below shows the data till current year-end.
Where
[Year] = '2021'
and [Fiscal Month Number]>=Month(Today();
Try something like this -
Where [Month Year] >= MonthStart(today(1),-18)
[Month Year] is a date type field and it stores start or end of the month value, kind of associated to all rows for any specific month something like Date(floor(monthend(DateField)),'MMM-YYYY')