Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dimension limit based on date

Hi! I have a straight table where I would like to put a dimension limit based on dates. In the table below I would like that all values from 2010-Dec up to (and including) 2011-Sep should be "Others". I do not want to use "largest values" since this might not be correct if the values change. Thanks

Dimension limit.PNG.png

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

Edit your dimension "Booking Month" and write:

if your field is [Booking Month] then

If([Booking Month] >= '2010-Dec' and [Booking Month] <= '2011-Sep', 'Others, [Booking Month])

View solution in original post

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Edit your dimension "Booking Month" and write:

if your field is [Booking Month] then

If([Booking Month] >= '2010-Dec' and [Booking Month] <= '2011-Sep', 'Others, [Booking Month])

Not applicable
Author

Thanks Alessandro! That worked great!

MK_QSL
MVP
MVP

If you don't want the result by Calculated Dimension, it's difficult as there is no Last selection in dimension limit.

Another work around is

Sort the Booking Months by descending order

Select First in dimension limit

In values write below formula

=COUNT(DISTINCT [Booking Month])-11

Change 11 accordingly...

Hope this helps...