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.
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
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 .