Limit Dimension values in Qliksense

[manojkumargowda]

Hi All,

My dimension values (createddate) are in MMM-YY format. It starts from Jan 2018 to Dec 2020. But I just want to show from jan 2018 to current + 3 months. what should be the dimension limit expression?

expression used to get MMM-YY (Date(monthstart(createddate), 'MMM-YY'))

[Chanty4u]

try

if (monthstart(mydates) > monthstart(addmonths(today(),-3)), mydates)

[manojkumargowda · Accepted solution]

Thanks Chanty,

I used similar expression and it worked.

=if(CraetedMonth<=(Date(monthstart(addmonths(Today(),3)), 'MMM-YY')),CreatedMonth)

where createdMonth= (Date(monthstart(createddate), 'MMM-YY'))

[Chanty4u]

Nice    Please close the thread