Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MuraliPrasath
Creator III
Creator III

show data only for 18 Months.

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();

Labels (2)
1 Reply
Digvijay_Singh

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')