Straight table

[gargi_bardhan]

Hi All,

Facing some issue in showing data as required by user :

Attaching the sample data for the same .

Help needed.

Thanks,

Gargi

[Peter_Cammaert]

How is QlikView to know which rows to merge and which rows not to merge? Merge a row with a blank VName toghether with a row with a non-blank VName? What happens if I have one row with a blank VName and two rows with a non-blank VName?

You'ld better describe what has to happen in this straight table.

Best,

Peter

[maxgro]

PFA

[gargi_bardhan]

Hi Peter ! Thanks for your time .

CName to VName is 1 :many relationship .

If for a CName(A)->

i) VName is Null -> NName has value (UUU)

OR

VName has value (GG) -> NName is Null

Like below :    

CName	VName	NName	VVal	NVal	Total
A		UUU	0	300	300
A	GG		200	0	200

Required is:

Merging of the two rows to one sum of there value NVal + VVal (300 + 200)  as shown below:

CName	VName	NName	VVal	NVal	Total
A	GG	UUU	200	300	500

Thanks again .

[gargi_bardhan]

Thanks Maxgro for the Solution and time . Right now looks good trying to implement in my original application . Will get back to you soon .

Help much appreciated.

Thanks,

Gargi

[Gysbert_Wassenaar]

See attached example.

[gargi_bardhan]

Thanks Gysbert for the time and help !

The NName is coming blank for CName (A/D),rest looks good .

Regards,

Gargi

[Gysbert_Wassenaar]

Hmm, ok, second attempt.

[gargi_bardhan]

Looks good ! will check with my application and get back to you .

Thanks,

Gargi