topic Dimension Last n days in QlikView

Dimension Last n days

arsenal1983 — Tue, 27 Oct 2015 13:33:30 GMT

Hello,

On the barchart I would like to show only last n days from my data (dete dimension).

n is a variable (slider).

I don't want to use set analysis (becaouse there is no possibility to skip to the details data)

I don't want to use x-scrollbar

I would like to set the dimesion length - this should be simple but I'm walking around.

THX

Luke

sunny_talwar — Tue, 27 Oct 2015 13:52:31 GMT

Not completely sure about your requirement, but may be something like this:

=If(Num(Date) <= Num(Today() - $(n)), Date)

and then select 'Suppress When Value is Null' option on the dimension tab of the chart properties.

arsenal1983 — Tue, 27 Oct 2015 14:22:54 GMT

I knew it is simple but it is absolutely trivial,

Thanks Sunny.