topic Re: If statement else nothing in QlikView

If statement else nothing

Fri, 20 Nov 2020 18:02:30 GMT

Hi,

I want to make a if statement already in teh laoding script. Lets say i have a list of 5 clients. If client is 3 then Banana else just keep the original valuesof 1,2,4,5.

Client:

3 = Banana

Is this possible?

Re: If statement else nothing

oknotsen — Fri, 22 Jan 2016 16:43:09 GMT

Lets assume the field this 1-5 is in is called "theField" (and A, B, C, E and F are random other fields from the same table):

LOAD

if(theField = 3, 'Banana', theField) as aField

from some source

;

Re: If statement else nothing

PradeepReddy — Fri, 22 Jan 2016 17:21:52 GMT

try like this...

Load *,

if(Client='3', 'Banana', Client) as Client

From Source;

Re: If statement else nothing

maxgro — Fri, 22 Jan 2016 17:48:13 GMT

another one could be

Client:

load

Client as ClientOrig,

pick(wildMatch(Client, 3, '*'), 'Banana', Client) as Client

inline [

Client

];

Re: If statement else nothing

Anonymous — Fri, 22 Jan 2016 17:53:59 GMT

For the best maintenance try this

Map_ClientName:

Mapping

LOAD * INLINE [

ID, Name

3, Banana

];

ClientTable:

Load

ApplyMap('Map_ClientName',Client) as Client

From Source.xls;

Applymap if no find ID in the Map_ClientName, put the original Client value.

So, if in the future you need other Name for your client, just add to the Map_ClientName.