topic Chart dimension date between 2 variables in QlikView

Chart dimension date between 2 variables

Mon, 28 Jul 2014 12:00:22 GMT

Hi,

I have 2 variables, dateStart and dateEnd.

I have a chart in which the dimension is a field with dates.

I would like the dimension to show only the values of the field which are between the 2 date variables - is it possible?

Thanks in advance,

Yael

Tue, 29 Jul 2014 06:46:48 GMT

I have found the solution:

In the dimnsion, put the following expression; =if(DATE_FIELD>='$(dateStart )' AND DATE_FIELD<='$(dateEnd)' ,DATE_FIELD,Null)

And check the checkbox "Suppress when value is null"