topic Re: Concat values from one field in QlikView

Concat values from one field

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm facing a problem with concat few values from one field.

EX: I have two column called State,Value and those values are like...

State,Value

A,10

B,5

C,12

D,8

I want

State,Value

A/B,15

C/D,20

Can any one please tell me how to get this done.

Thanks in Advance.

Regards,

Arjun

Re: Concat values from one field

sunny_talwar — Fri, 22 Apr 2016 12:58:09 GMT

What is the logic behind combining 1st 2 together and next 2 together? Is there another dimension based on which you want to combine them?

Re: Concat values from one field

sunny_talwar — Fri, 22 Apr 2016 12:59:47 GMT

May be like this:

Table:

LOAD * INLINE [

Dim, State Value

1, A, 10

1, B, 5

2, C, 12

2, D, 8

];

FinalTable:

NoConcatenate

LOAD Dim,

Concat(State, '/') as State,

Sum(Value) as Value

Reisdent Table

Group By Dim;

Drop Table Table;

Re: Concat values from one field

Fri, 22 Apr 2016 13:00:15 GMT

Hi Sunny,

There is no logic behind doing this, need to combine few dimension values.

I'm not sure how to do this.

Re: Concat values from one field

Kushal_Chawda — Fri, 22 Apr 2016 13:03:00 GMT

you should have data like this, then only you will be able to use the concat

Data:

LOAD * inline [

ID,State,Value

1,A,10

1,B,5

2,C,12

2,D,8 ];

New:

noconcatenate

LOAD ID,

Concat(distinct State,'/') as State,

sum(Value) as Value

resident Data

group by ID;

drop table Data;

Re: Concat values from one field

sunny_talwar — Fri, 22 Apr 2016 13:04:13 GMT

Need some basis to know what will be combined into groups, right? How else will you do it in your scenario?

Re: Concat values from one field

sunny_talwar — Fri, 22 Apr 2016 13:04:41 GMT

Drop Table Data you mean

Re: Concat values from one field

Kushal_Chawda — Fri, 22 Apr 2016 13:26:59 GMT

Yes, bhavnao ko samjo

Re: Concat values from one field

sunny_talwar — Fri, 22 Apr 2016 13:30:41 GMT

samjh gaya

Re: Concat values from one field

Anil_Babu_Samineni — Fri, 22 Apr 2016 14:00:12 GMT

Kushal, I have one question.. What is the difference between your code and Sunny Code. Could you please elaborate that. Because, Sunny code is fine for that Issue....

Re: Concat values from one field

Kushal_Chawda — Fri, 22 Apr 2016 14:57:51 GMT

There is no difference but I can make difference like below

Front end solution

create the straight table

Dimension:

Expression:

1) State - concat( distinct State,'/')

2) Value - sum(Value)