topic Re: Separate two different things in the script in QlikView

Separate two different things in the script

Anonymous — Tue, 15 Dec 2015 15:00:22 GMT

Hi, QV

I have a dataset in my company that you can see below

The problem I have is that the IDs that are scanned get Scanned Type = LOCATE.

But I want separate if the ID is scanned at Hub From or Hub To.

I need the scanned type to have something like LOCATE_FROM and LOCATE_TO.

How can make something like that in the script?

Any ideas?

sergiorey — Tue, 15 Dec 2015 15:13:16 GMT

May be adding these lines in your LOAD statement:

...

If([Scanned Hub]=[Hub From], [Hub From]) AS LOCATE_FROM,

If([Scanned Hub]=[Hub To], [Hub To]) AS LOCATE_TO,

...

Hope it helps.

Regards,

Sergio.

Gysbert_Wassenaar — Tue, 15 Dec 2015 15:34:47 GMT

Maybe like this:

LOAD ID,

[Hub From],

[Hub To],

If([Scanned Hub]=[Hub From], [Scanned Type] & '_FROM' ,

If([Scanned Hub]=[Hub To], [Scanned Type] & '_TO' , [Scanned Type])) as [Scanned Type],

[Scanned Hub]

FROM

[Qlikview Data - Scanned.xls]

(biff, embedded labels);