topic Re: Expression Error in QlikView

Expression Error

asknyldz — Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

My Expression is,

=(sum({<TYPE={'ACTUAL'},[BUSINESS]={'New','Expanded'}>-<CLIENT={'NEW CLIENTS','EXPANDED CLIENTS','FORECAST ADJUSTMENT'}>}AMOUNT))/1000

Thats mean, Business should be New and Expanded.

I Click Renewal, why i see New and Expanded.figures in my data?

Thanks

Re: Expression Error

markodonovan — Thu, 21 Apr 2016 15:17:03 GMT

Hi Askin,

Could you upload the sheet or show the current selections ?

I assumed they are the same field.

Mark

Re: Expression Error

Nicole-Smith — Thu, 21 Apr 2016 15:19:12 GMT

It's because in the set analysis you're telling it to only look at New and Expanded. If you want it to take into account your selections, you can use the P() function with it:

=(sum({<TYPE={'ACTUAL'},[BUSINESS]={'New','Expanded'}*P([BUSINESS])>-<CLIENT={'NEW CLIENTS','EXPANDED CLIENTS','FORECAST ADJUSTMENT'}>}AMOUNT))/1000

Re: Expression Error

asknyldz — Fri, 22 Apr 2016 09:52:36 GMT

Dear Nicole,

Thats perfect solution is P()

Regards,

Askin