Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Contributor II

Variable Error



I have been asked to look at a dashboard that has recently started throwing an error in a chart expression.


The expression is :

=sum({<$(vSum)>} [Total Cost])


Where vSum is :

[Order Date]={'>$(=addmonths(Max([Order Date]),-12,1))'},[Employee]-={'HarrisonEG'}

The Variable is throwing an error and I can't work out the correct way to express it.   I Basically want to sum Total Costs for the previous 12 months excluding a particular employee.   

Any help appreciated,



Labels (2)
3 Replies

Re: Variable Error

Hi Phil, usaully in set analysis single quotes are used to look for literal values, and double quotes for comparison, so try with:
[Order Date]={">$(=addmonths(Max([Order Date]),-12,1))"},[Employee]-={'HarrisonEG'}
Contributor II

Re: Variable Error


Thanks for the reply.  I have altered the quotes as per your suggestion and im still getting an error in expression on....


Re: Variable Error

Hi, it works for me, PFA.

Note that syntax checker will say 'Errors in expression' but it still works.