topic Re: if statement in QlikView

if statement

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

is it possible to have if condition with 2 values for ex:

if country = france then 'Europe' ,'french' else 'other'...

europe and french should be 2 diff values.

Re: if statement

Anil_Babu_Samineni — Thu, 21 Dec 2017 09:17:02 GMT

May be this?

If((country = 'france', 'Europe') or (country = 'france', 'french'), 'other')

Re: if statement

prat1507 — Thu, 21 Dec 2017 09:47:32 GMT

Where are you planning to use this and why do you want it as two values and not a single value like Europe,French.

Regards
Pratyush

Re: if statement

raadwiptec — Thu, 21 Dec 2017 09:50:07 GMT

because europe and french is refereeed as 2 different dimension in our database and the values diff little when you select europe and french seperately

Re: if statement

raadwiptec — Thu, 21 Dec 2017 09:53:25 GMT

hi anil

can you also suggest the same for multiple countries.. ex: if country like france ,italy, spain then 'Europe' ,'french' else 'other'...

Re: if statement

Anil_Babu_Samineni — Thu, 21 Dec 2017 09:56:45 GMT

Here we go !!

If((Match(country, 'france', 'italy', 'spain'), 'Europe') or (Match(country, 'france', 'italy', 'spain'), 'french'), 'other')

Re: if statement

t_chetirbok — Thu, 21 Dec 2017 10:12:00 GMT

do you want to have two rows for one Country in the table?

Re: if statement

t_chetirbok — Thu, 21 Dec 2017 10:14:46 GMT

something wrong

If(

( Match(country, 'france', 'italy', 'spain'), 'Europe')

or ( Match(country, 'france', 'italy', 'spain'), 'french')

, 'other')

did you want to put additional if before match?

Re: if statement

raadwiptec — Thu, 21 Dec 2017 10:16:07 GMT

hi anil,

there is some problem with the syntax.. iam not able to figure out. syntax ..below all the scripts gets black

Re: if statement

raadwiptec — Thu, 21 Dec 2017 10:24:18 GMT

hi tats, yes indeed

Re: if statement

t_chetirbok — Thu, 21 Dec 2017 10:37:28 GMT

you can try this:

Table:

load

if(match(Country, 'france', 'italy', 'spain') ,if(IterNo()=1,Country, 'europe') , 'other') as New_Column

, Country

, Value

while iterno()<=if(match(Country, 'france', 'italy', 'spain'),2,1);

load * inline

[

Country, Value

france, 100

italy, 200

spain, 300

USA, 150

]

;

I'm not sure if it's that you are looking for