Discussion Board for collaboration on QlikView Layout & Visualizations.
I found out a strange thing in QV 11.
I have a chart with this expression -
In QV 10, it worked nicely.
But in QV 11 the expression isn't working at all.
If I change it to - =SUM(if(RECORD_DATE>$(vToday),COUNT,0)) then everything is working fine.
After I saw this, I looked at more objects that use variables in set analisys, and they don't work as well.
Is this a known bug?
Is there any solution?
Go to Solution.
In the past I had problems with date formats in set analysis.I'm not sure if this can be your case.
I used to create a field where the date is a simple integer. In script, this can be done with a simple num():
num(RECORD_DATE) as nDate
Then, vToday would also be a number:
vToday = num(today() ) ;
Thus, set analysis will become:
Hope this helps,
Try adding an equals sign to the dollar sign expansion like:
It worked nicely thanks!