topic Script Debugging help in QlikView

Script Debugging help

Wed, 14 Nov 2012 06:41:41 GMT

please help debugging the script below

if ( "REPORTTYPE" = 'FP UNPAIDS GREATER THAN 2',"REPORTVALUE" * -1,

If ( "PLANCODE" = 1560,"REPORTVALUE" * -1,"REPORTVALUE" )) As "Sum of Mailshots",

thanks in advance

Re: Script Debugging help

Anonymous — Wed, 14 Nov 2012 06:58:47 GMT

Don't use quotes (") around your field names. That will make it a string instead of referencing the field.

Re: Script Debugging help

Wed, 14 Nov 2012 07:03:17 GMT

if ( REPORTTYPE = 'FP UNPAIDS GREATER THAN 2', REPORTVALUE * -1 ,

If ( PLANCODE = 1560, REPORTVALUE * -1, REPORTVALUE )) As [Sum of Mailshots]

OR you can also try:

if ( REPORTTYPE = 'FP UNPAIDS GREATER THAN 2' or PLANCODE = 1560, REPORTVALUE * -1 , REPORTVALUE ) As [Sum of Mailshots]

I'm assuming REPORTTYPE, PLANCODE & REPORTVALUE are correctly spelt names and they exist in your model and that PLANCODE & REPORTVALUE are numeric.

Re: Script Debugging help

Wed, 14 Nov 2012 07:12:48 GMT

Hi,

I was told if i use double qoutes it works the same as square brackets and only makes it a field if i used single quotes