topic Re: Variable Error in QlikView

Variable Error

prees959 — Sat, 16 Nov 2024 04:09:50 GMT

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

Re: Variable Error

rubenmarin — Thu, 14 Mar 2019 21:42:57 GMT

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'}

Re: Variable Error

prees959 — Thu, 14 Mar 2019 22:04:54 GMT

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

rubenmarin — Fri, 15 Mar 2019 07:24:05 GMT

Hi, it works for me, PFA.

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