Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
manojkumargowda
Creator
Creator

Limit Dimension values in Qliksense

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

1 Solution

Accepted Solutions
manojkumargowda
Creator
Creator
Author

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

View solution in original post

3 Replies
Chanty4u
MVP
MVP

try

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

manojkumargowda
Creator
Creator
Author

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
MVP
MVP

Nice    Please close the thread