topic Re: How can I limit my dimension? in QlikView

How can I limit my dimension?

brunolelli87 — Wed, 25 Nov 2020 16:16:04 GMT

Hello guys,

I'm using a date field (DD/MM/YYYY) as dimension, called PERI.
This field contains values from 01/01/2015 up to 01/01/2025, but I don't want to show values from today up to 01/01/2020, how can I do it?

I would like to show just the past values up to today!

Example:
01/01/2015,
02/01/2015,

...
today()

Thanks

Re: How can I limit my dimension?

Arthur_Fong — Tue, 19 May 2020 16:37:30 GMT

How would you like to do this? Front End or Script?

Re: How can I limit my dimension?

brunolelli87 — Tue, 19 May 2020 17:06:30 GMT

I prefer via script, but it’s up to you!

Thanks

Re: How can I limit my dimension?

brunolelli87 — Tue, 19 May 2020 18:25:58 GMT

Any idea?

Re: How can I limit my dimension?

Saravanan_Desingh — Tue, 19 May 2020 21:43:22 GMT

Something like prepare the Calendar.

tabCalendar: LOAD Date(MinDate+(IterNo()-1)) as TranDate, If(Date(MinDate+(IterNo()-1))>='1/1/2020' And Date(MinDate+(IterNo()-1))<=Today(), 'N', 'Y') As DimFlag While MinDate+IterNo() <= MaxDate; LOAD '1/1/2015' As MinDate, '1/1/2025' As MaxDate AutoGenerate 1;

In the Dimension.

If(DimFlag='Y',TranDate)