topic Re: Straight table in QlikView

Straight table

gargi_bardhan — Thu, 19 Nov 2015 12:38:45 GMT

Hi All,

Facing some issue in showing data as required by user :

Attaching the sample data for the same .

Help needed.

Thanks,

Gargi

Re: Straight table

Peter_Cammaert — Thu, 19 Nov 2015 12:46:55 GMT

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

Re: Straight table

maxgro — Thu, 19 Nov 2015 13:06:15 GMT

PFA

Re: Straight table

gargi_bardhan — Thu, 19 Nov 2015 13:08:19 GMT

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)

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 .

Re: Straight table

gargi_bardhan — Thu, 19 Nov 2015 13:13:43 GMT

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

Re: Straight table

Gysbert_Wassenaar — Thu, 19 Nov 2015 13:15:59 GMT

See attached example.

Re: Straight table

gargi_bardhan — Thu, 19 Nov 2015 14:08:22 GMT

Thanks Gysbert for the time and help !

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

Regards,

Gargi

Re: Straight table

Gysbert_Wassenaar — Thu, 19 Nov 2015 14:11:37 GMT

Hmm, ok, second attempt.

Re: Straight table

gargi_bardhan — Thu, 19 Nov 2015 14:14:24 GMT

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

Thanks,

Gargi