topic Re: How to modify script so that it can have min and max range control ? in QlikView

How to modify script so that it can have min and max range control ?

paulyeo11 — Tue, 07 May 2013 01:00:38 GMT

Hi All

My script below :-

if(num(@124:129T)<'50099','4 CURRENT ASSET 0 - 50099',

if(num(@124:129T)<'70099','5 CURRENT LIABILITY 50100 - 70099',

)) as [NAME_],

it will filter

from 0-50099 as for Current Asset.

from 50100-70099 as for Current Liability.

My question is how to modify the above script so that it will :-

from 50000-50099 as for Current Asset.

from 60100-70099 as for Current Liability.

Hope some one can advise me.

Paul

Re: How to modify script so that it can have min and max range control ?

Sokkorn — Tue, 07 May 2013 02:12:50 GMT

Hi Paul,

I'm not sure you try this script yet

If(Num(@124:129T)>=50000 and Num(@124:129T)=<50099,'4 CURRENT ASSET 0 - 50099',

If(Num(@124:129T)>=60100 and Num(@124:129T)=<70099,'5 CURRENT LIABILITY 60100 - 70099')) as [NAME_],

By the way, QlikView recognise filter value '50099' as a string. So to avoid conflict script translation, we should use it in number format(because you used Num(@124:129T) that one return in number format).

Regards,

Sokkorn

Re: How to modify script so that it can have min and max range control ?

paulyeo11 — Tue, 07 May 2013 02:28:33 GMT

Hi Sokkom

Many thank for your script, I manage detect one error

If(Num(@124:129T)>=50000 and Num(@124:129T)=<50099,'4 CURRENT ASSET 0 - 50099',

If(Num(@124:129T)>=60100 and Num(@124:129T)=<70099,'5 CURRENT LIABILITY 60100 - 70099'

need to add a , here

)) as [NAME_],

even i manage detect the error , i still get error. may be you can help me again ?

Paul

Re: How to modify script so that it can have min and max range control ?

Sokkorn — Tue, 07 May 2013 02:40:26 GMT

Ah... Paul. That is my mistake in script level .

Previous script

If(Num(@124:129T)>=50000 and Num(@124:129T)=<50099,'4 CURRENT ASSET 0 - 50099',

If(Num(@124:129T)>=60100 and Num(@124:129T)=<70099,'5 CURRENT LIABILITY 60100 - 70099')) as [NAME_NEW],

Modified to

If(Num(@124:129T)>=50000 and Num(@124:129T)<=50099,'4 CURRENT ASSET 0 - 50099',

If(Num(@124:129T)>=60100 and Num(@124:129T)<=70099,'5 CURRENT LIABILITY 60100 - 70099')) as [NAME_NEW],

Try it and take a look.

Rgds,

Sokkorn

Re: How to modify script so that it can have min and max range control ?

paulyeo11 — Tue, 07 May 2013 02:57:38 GMT

Hi Sokkom , it work fine now. Thank you