topic Combining two rows as one in QlikView

Combining two rows as one

Abhi999 — Wed, 03 Jun 2020 14:20:40 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

AshvitaKatkar — Wed, 03 Jun 2020 19:24:07 GMT

Hi Abhi,

On which criteria your want to combine two rows as one???

Regards,

Ashvita

Abhi999 — Wed, 03 Jun 2020 19:29:43 GMT

Hi Sawant,

No criteria nothing just want like this

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

AshvitaKatkar — Wed, 03 Jun 2020 20:13:49 GMT

Hi Abhi,

Assuming you don't want to combine Mohan and Prathap you can execute following experience in frontend chart:

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

Measure: =Sum(Amount)

Regards,

Ashvita

Abhi999 — Wed, 03 Jun 2020 20:41:30 GMT

Thank you Asvita, it works fine for me.