topic Re: Scripting in QlikView

Scripting

upaliwije — Wed, 24 Sep 2014 07:06:28 GMT

I load following data first

Vehicle_No Value

1 50000

2 100000

3 75000

4 125000

5 200000

Then I through a Join load the YEAR_OF_MAKE of some vehicle. Finally my data look as follows

Vehicle_No Value Year_of_Make

1 50000 2011

2 100000

3 75000 2013

4 125000 2014

5 200000

Now I want classify the year of make as follows in the load script

YOM

2011

2013

2014

Others (where there is no year of Make)

Kindly help me to write the script for this

Re: Scripting

senpradip007 — Wed, 24 Sep 2014 07:09:28 GMT

Try like:

Load

If(Len(Year_of_Make)<>0, Year_of_Make, 'Others') AS YOM,

......

From <>;

Re: Scripting

senarath — Wed, 24 Sep 2014 07:12:26 GMT

Hi,

You could also use Is Null function in load script where Qlikview will load null fields as Others.

thanx

Re: Scripting

ychaitanya — Wed, 24 Sep 2014 07:15:12 GMT

ALT(Year_Of_Make,'Others') as YOM

Re: Scripting

jyothish8807 — Wed, 24 Sep 2014 07:16:42 GMT

Hi Upali,

Try this:

Load

If(Len(trim(Year_of_Make))<>0, Year_of_Make, 'Others') AS YOM,

from ...<>

You can try this also:

if(isnull(Year_of_Make)=-1,'Others',Year_of_Make)

Regards

Re: Scripting

maxgro — Wed, 24 Sep 2014 07:25:06 GMT

NewTable:

load

Vehicle_No,

Value

if(len(trim(Year_of_Make))>0, Year_of_Make, 'Others') as YOM

resident

OldTable;

drop table OldTable;

Re: Scripting

Anonymous — Wed, 24 Sep 2014 07:26:04 GMT

you can add in the beginning of your script:

set NullValue='Others';

Re: Scripting

upaliwije — Wed, 24 Sep 2014 08:34:01 GMT

TKS ALL