topic Invalid expression error in qlikview in QlikView

Invalid expression error in qlikview

sindhura — Mon, 22 Aug 2016 19:41:58 GMT

I have script in the following way. When I execute this script,i encounteres the invalid expression error, specifically in the line

if(isnull(REFERENCE),if(VALUE >0, VALUE)) as NA_VALUE.

Kindly solve this asap.

load
REFERENCE,
agrmt,
if(sum(NA_VALUE)>0,NA_VALUE ,0) as R_V
group by agrmt,REFERENCE
;
Load
REFERENCE,
VALUE,
NA_VALUE,
if(isnull(REFERENCE), 'No Netting Agreement',REFERENCE) as agrmt
;

Load
REFERENCE,
VALUE,
if(isnull(REFERENCE),if(VALUE >0, VALUE)) as NA_VALUE
From A;

Re: Invalid expression error in qlikview

sunny_talwar — Mon, 22 Aug 2016 20:11:45 GMT

Would you be able to post a screenshot of the error?

Re: Invalid expression error in qlikview

sindhura — Mon, 22 Aug 2016 20:21:07 GMT

Re: Invalid expression error in qlikview

maxgro — Mon, 22 Aug 2016 20:23:54 GMT

add a sum in the load with the group by

load

REFERENCE,

agrmt,

if(sum(NA_VALUE)>0,sum(NA_VALUE) ,0) as R_V

group by agrmt,REFERENCE

;

Re: Invalid expression error in qlikview

sunny_talwar — Mon, 22 Aug 2016 20:31:17 GMT

I think try out maxgro solution, he might be right

Re: Invalid expression error in qlikview

maxgro — Mon, 22 Aug 2016 20:37:03 GMT

This is the script I used to test the syntax for my answer (difference with your first post is in bold)

load * inline [

REFERENCE, VALUE

1,0

0,1

];

load

REFERENCE,

agrmt,

if(sum(NA_VALUE)>0,sum(NA_VALUE) ,0) as R_V

group by agrmt,REFERENCE

;

Load

REFERENCE,

VALUE,

NA_VALUE,

if(isnull(REFERENCE), 'No Netting Agreement',REFERENCE) as agrmt

;

Load

REFERENCE,

VALUE,

if(isnull(REFERENCE),if(VALUE >0, VALUE)) as NA_VALUE

Resident A;

Re: Invalid expression error in qlikview

Anonymous — Tue, 23 Aug 2016 06:15:54 GMT

Hi, try with this:

if(isnull(REFERENCE) AND VALUE > 0, VALUE) as NA_VALUE

Regards!