topic Re: Choose 2 Dates to get the data. in QlikView

Choose 2 Dates to get the data.

Mon, 30 Jun 2014 21:41:10 GMT

Hello Everyone,

I have two variables vThisMonth = 06/15/2014;

and vLastSixmonth = Addmonths('$(vThisMonth)',-6);

I want to create a chart where expression shows max(Score) between there two variables in other words between last 6 months, I've tried :

max({<Date = {">=$(vThisMonth)<=$(vLastSixmonth)"}>}Score)

However, the data is not displayed correctly, any ideas?

Thanks in advance.

Re: Choose 2 Dates to get the data.

vgutkovsky — Mon, 30 Jun 2014 21:48:40 GMT

Do you mean your vThisMonth variable is literally hardcoded to "=06/15/2014"? If so, QV doesn't understand that that's a date. Try =date#('06/15/2014')

Regards,

Vlad

Re: Choose 2 Dates to get the data.

Mon, 30 Jun 2014 21:53:27 GMT

Thanks Vlad,

no, vThisMonth is being dynamically created by resident loading of max(date) from one of the table.

Re: Choose 2 Dates to get the data.

vgutkovsky — Mon, 30 Jun 2014 22:01:28 GMT

Oh, wait a second, just noticed that your condition is reversed Flip your <= and >= signs.

Regards,

Vlad