topic Re: Combine two rows as one in QlikView

Combine two rows as one

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

Hi i need your help to get output like below.

I have two fields

Name Amount

Suresh 100

Mohan 200

Prathap 300

Sai 500

I want to combine Suresh and Sai as one, required output like below

Name Amount

Suresh+Sai 600

Mohan 200

Prathap 300

Re: Combine two rows as one

Taoufiq_Zarra — Wed, 03 Jun 2020 15:03:05 GMT

@Abhi999 for example :

Data: load if(Name='Suresh' or Name='Sai','Suresh+Sai',Name) as Name,Amount inline [ Name,Amount Suresh,100 Mohan,200 Prathap,300 Sai,500 ] ; output: noconcatenate load Name,sum(Amount) as NewAmount resident Data group by Name; drop table Data;

Re: Combine two rows as one

Abhi999 — Wed, 03 Jun 2020 15:16:15 GMT

thank you, is it possible in front end instead of script.

Re: Combine two rows as one

Taoufiq_Zarra — Wed, 03 Jun 2020 15:20:06 GMT

@Abhi999

In front :

Add dimension : =if(Name='Suresh' or Name='Sai','Suresh+Sai',Name)

Measure: =Sum(Amount)

Re: Combine two rows as one

Abhi999 — Wed, 03 Jun 2020 15:50:13 GMT

thanks your quick response, i want to show Prathap and mohan aswell not only Suresh and Sai .

I am expecting below:

Suresh and Sai as on row and remaining as usual.

Re: Combine two rows as one

Taoufiq_Zarra — Wed, 03 Jun 2020 16:03:25 GMT

attached qvw example

that's what I sent

Re: Combine two rows as one

Abhi999 — Wed, 03 Jun 2020 20:40:37 GMT

Thank you Zarra, it works fine for me.

Re: Combine two rows as one

Abhi999 — Thu, 04 Jun 2020 12:54:58 GMT

Is it possible to show

Suresh and said seperate and suresh+Sai seperate ?

Re: Combine two rows as one

Abhi999 — Thu, 04 Jun 2020 12:59:23 GMT

Using below we are able to combine Suresh and said show count. But I want to show Sai and Suresh seperatly and sures+Sai aswell.

dimension : =if(Name='Suresh' or Name='Sai','Suresh+Sai',Name)

Re: Combine two rows as one

Abhi999 — Thu, 04 Jun 2020 13:02:56 GMT

Using below we are able to combine Suresh and said show count. But I want to show Sai and Suresh seperatly and suresh+Sai aswell.

dimension : =if(Name='Suresh' or Name='Sai','Suresh+Sai',Name)