topic Re: Error in Expression in QlikView

Error in Expression

upaliwije — Fri, 17 Oct 2014 09:31:39 GMT

if((Sum(ACTUAL)/$(=$(=vActual))*100)<0,Sum(ACTUAL)/$(=$(=vActual))*100)*-1,Sum(ACTUAL)/$(=$(=vActual))*100

The above expression in my Pivot Table does not work. Will someone have a look at this and correct me please

Re: Error in Expression

simondachstr — Fri, 17 Oct 2014 09:36:58 GMT

Can you disclose the content of vActual variable.. And when you say it doesn't work - is the expression not OK in the expression editor or do you get null as a result where you were expecting values?

Re: Error in Expression

upaliwije — Fri, 17 Oct 2014 09:43:18 GMT

sum({$<DESCRIPTION={'GROSS_PREMIUM'}>}ACTUAL)

Expression is ok in expression editor Expected Value is shown as -

Re: Error in Expression

Anonymous — Fri, 17 Oct 2014 09:48:21 GMT

Try a simplified experssion:

=fabs((Sum(ACTUAL)/$(=$(=vActual))*100))

Marc.

Re: Error in Expression

upaliwije — Fri, 17 Oct 2014 09:54:57 GMT

Thanks All