topic Re: If clause with multiple fileds in App Development

If clause with multiple fileds

stonecold111 — Sat, 16 Nov 2024 00:35:22 GMT

Hi qlikss

I have a table

NUM name. Name2

1. 0. 0

2. John. 0

3. 0. Roc

I want my output table like this

NUM name. Name2. Comment

1. 0. 0. Name is zero

1. 0. 0. Name2 is zero

2. John. 0. Name2 is zero

3. 0. Roc. Name is zero

Someone help me

Re: If clause with multiple fileds

stonecold111 — Wed, 17 Feb 2021 12:21:30 GMT

@swuehl

Help me

Re: If clause with multiple fileds

Rqlik1 — Wed, 17 Feb 2021 12:24:57 GMT

Try if([name.] = '0.', 'Name is zero', if([Name2.] = '0.', 'Name2 is zero', 'Not zero'))

Re: If clause with multiple fileds

stonecold111 — Wed, 17 Feb 2021 13:08:39 GMT

But I want name is zero and name2 is zero

For same number

Re: If clause with multiple fileds

stonecold111 — Wed, 17 Feb 2021 13:09:52 GMT

I want same comments that shown above

Re: If clause with multiple fileds

QFabian — Wed, 17 Feb 2021 14:29:26 GMT

Hi @stonecold111 , a lot of fun with this, i just create this example, considering that the dots doesnt exists, if they exists, just replace 0 with '0.' :

DataX:
Load * INLINE [
Num, Name, Name2
1, 0,0
2,John Cena,0
3,0, The Rock
];

Comment:
Load
Num,
if(Name = 0, 'Name is Zero') as Comment
Resident DataX;

Load
Num,
if(Name2 = 0, 'Name2 is Zero') as Comment
Resident DataX;

This is the result,

please consider this :

Let my know if this is an acceptable solution!

Re: If clause with multiple fileds

Saravanan_Desingh — Wed, 17 Feb 2021 14:46:17 GMT

Try this,

tab1: Load * INLINE [ Num, Name, Name2 1, 0,0 2,John Cena,0 3,0, The Rock ]; tab1X: CrossTable(Names, Value) LOAD * Resident tab1; Left Join(tab1) LOAD Num, Concat(DISTINCT If(Value=0,Names&' is Zero'),', ') As Comment Resident tab1X Group By Num; Drop Table tab1X;

Re: If clause with multiple fileds

Saravanan_Desingh — Wed, 17 Feb 2021 14:46:42 GMT

Output:

Re: If clause with multiple fileds

stonecold111 — Thu, 18 Feb 2021 06:48:23 GMT

Thank s Fabian.

Worked like charm.

Even the names that I have in my mind are jhon cena and Dwayne the rock Johnson when I'm typing my sample data😁

You guessed it right.

Another way of doing is with cross table.

Thanks all of you.

Re: If clause with multiple fileds

stonecold111 — Thu, 18 Feb 2021 06:42:03 GMT

Thanks sarand7.

I can accept only one reply as solution.

You both are awesome.