topic script in QlikView

script

upaliwije — Mon, 06 Apr 2015 23:05:19 GMT

I have written the following line in my load script

IF(CL_OBAL>0 and (CL_OBAL-CL_ADJUS)=0 AND CL_CBAL=0,-1)AS NOs

Though the script is nut I do not get the desired results(Nos as negative figure) Pls help me whether there is a better way of writing the code

Anonymous — Mon, 06 Apr 2015 23:35:55 GMT

try using nested if statements for each condition.

JonnyPoole — Mon, 06 Apr 2015 23:37:22 GMT

what are some sample values for CL_OBAL , CL_ADJ, and CL_CBAL ?

you might need to round to integers first...

IF(CL_OBAL>0 and round(CL_OBAL)=round(CL_ADJUS) AND CL_CBAL=0,-1)AS NOs

or if there are 2 decimals

IF(CL_OBAL>0 and round(CL_OBAL*100)=round(CL_ADJUS*100) AND CL_CBAL=0,-1)AS NOs

and check out:

danieloberbilli — Tue, 07 Apr 2015 00:42:20 GMT

Maybe your fields have Nulls instead of zeros. In this case try something like

if(len(CL_CBAL)=0

if(IsNull(CL_CBAL), ...

robert_mika — Tue, 07 Apr 2015 05:25:56 GMT

What's your data?

What's your desired result?

avinashelite — Tue, 07 Apr 2015 05:52:44 GMT

can you please share your with sample data so that we can help you

Anonymous — Tue, 07 Apr 2015 05:57:31 GMT

This is more towards data quality so scripts need to be modified as per the requirements of data

it would be great if you can share the sample qvw for further help