topic Re: Dimension limit based on date in QlikView

Dimension limit based on date

Tue, 15 Apr 2014 08:56:15 GMT

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

Re: Dimension limit based on date

alexandros17 — Tue, 15 Apr 2014 08:58:47 GMT

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

Re: Dimension limit based on date

Tue, 15 Apr 2014 09:16:35 GMT

Thanks Alessandro! That worked great!

Re: Dimension limit based on date

MK_QSL — Tue, 15 Apr 2014 09:17:49 GMT

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