topic if condition in load statement in QlikView

if condition in load statement

0li5a3a — Fri, 16 Jun 2017 09:21:07 GMT

Hi All,

table:

load

id,

column 1

from test.qvd

The information in the columns are like below

id column1

1 a

2 b

3 c

4 a

5 c

6 b

7 d

8 d

I would like to group all the a and b to name the column ab and c and d to be column cd.

I tried to use if function in the load script but I think this is not the right option.

Could you please advice ?

Re: if condition in load statement

Anil_Babu_Samineni — Fri, 16 Jun 2017 09:27:40 GMT

What would be the output from given data

Re: if condition in load statement

0li5a3a — Fri, 16 Jun 2017 09:38:37 GMT

Main qvd			My new Chart1			My new Chart2
ID	Name	Status	ID	Name	Status	ID	Name	Status
1	Jo	A	1		A	4	Mo	D
2	Mo	B	2		B	5	to	D
3	to	B	3		B	6	Mo	A
4	MO	C	7		A	8	to	C
5	Mo	D	9		A
6	to	D	10		B
7	Mo	A
8	to	C
9	Mo	A
10	to	B

Re: if condition in load statement

Anil_Babu_Samineni — Fri, 16 Jun 2017 09:54:21 GMT

Like this?

Re: if condition in load statement

0li5a3a — Fri, 16 Jun 2017 10:01:05 GMT

Yes

Re: if condition in load statement

0li5a3a — Fri, 16 Jun 2017 10:07:12 GMT

I want to create chart1 and chart2 using first table because this is my qvd.

I tried something like this:

table:

load

id,

column1,

if(column1= 'a',if(column1='b')) as ab,

if(column1 = 'c', if(column1= 'd)) as cd'

from test.qvd

Then I want to make a table box to look like this:

chart1

id ab

1 a

2 b

3 a

and

chart2

id cd

4 c

5 d

6 c

Re: if condition in load statement

Anil_Babu_Samineni — Fri, 16 Jun 2017 10:24:09 GMT

Can you use like below

LOAD id, column1, If(WildMatch(column1,'A','B'), column1) as ab, If(WildMatch(column1,'C','D'), column1) as cd;

LOAD * Inline [

id, column1

1 , A

2 , B

3 , B

4, C

5, D

6, D

7, A

8, C

9, A

10, B

];

Re: if condition in load statement

Kushal_Chawda — Fri, 16 Jun 2017 10:56:01 GMT

Chart 1

Dimension:

Name

Expression:

only({<Status={'A','B'}>}Status)

Chart 2

Dimension:

Name

Expression:

only({<Status={'C','D'}>}Status)

Re: if condition in load statement

0li5a3a — Fri, 16 Jun 2017 10:57:35 GMT

A big thank you!