Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Oh, wait a second, just noticed that your condition is reversed Flip your <= and >= signs.
Regards,
Vlad
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
Thanks Vlad,
no, vThisMonth is being dynamically created by resident loading of max(date) from one of the table.
Oh, wait a second, just noticed that your condition is reversed Flip your <= and >= signs.
Regards,
Vlad