Invalid expression error in qlikview

[sindhura]

hi

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;

[sunny_talwar]

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

[sindhura]

[maxgro]

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

;

[sunny_talwar]

I think try out maxgro solution, he might be right

[maxgro]

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

A:

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;

[Anonymous]

Hi, try with this:

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

Regards!