topic Re: Combining two row and show row seperatly in QlikView

Combining two row and show row seperatly

Abhi999 — Thu, 04 Jun 2020 14:00:35 GMT

If i gave below expression i am getting

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

Measure: =Sum(Amount)

Name Amount

Suresh+Sai 600

Mohan 200

Prathap 300

But i want output as like mentioned below.

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

Suresh 100

Sai 500

Mohan 200

Prathap 300

Re: Combining two row and show row seperatly

Saravanan_Desingh — Fri, 05 Jun 2020 01:51:28 GMT

Can you try this?

Dimensions:

Dim =If(Dim=1,'Suresh+Sai',Name)

Expression:

If(Dim=1,Sum({<Name={'Suresh'}>+<Name={'Sai'}>}Amount), Sum(Amount))

Re: Combining two row and show row seperatly

Saravanan_Desingh — Fri, 05 Jun 2020 01:52:50 GMT

tab1: LOAD * INLINE [ Name, Amount Suresh, 100 Mohan, 200 Prathap, 300 Sai, 500 ]; Dim: LOAD * INLINE [ Dim 1 2 ];

Re: Combining two row and show row seperatly

Saravanan_Desingh — Fri, 05 Jun 2020 01:56:00 GMT

We can do it Script as below.

tab1: LOAD * INLINE [ Name, Amount Suresh, 100 Mohan, 200 Prathap, 300 Sai, 500 ]; Concatenate(tab1) LOAD 'Suresh+Sai' As Name, Sum(Amount) As Amount Resident tab1 Where Match(Name,'Suresh','Sai') ;

Re: Combining two row and show row seperatly

Saravanan_Desingh — Fri, 05 Jun 2020 01:56:50 GMT

Re: Combining two row and show row seperatly

Abhi999 — Fri, 05 Jun 2020 09:29:22 GMT

Thanks saran working fine.

Re: Combining two row and show row seperatly

Saravanan_Desingh — Fri, 05 Jun 2020 13:10:22 GMT

you welcome