Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

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.

Highlighted
prees959
Contributor II

Variable Error

Hi,

 

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,

 

Phil

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'}
prees959
Contributor II

Re: Variable Error

Hi,

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.