Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Facing some issue in showing data as required by user :
Attaching the sample data for the same .
Help needed.
Thanks,
Gargi
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
PFA
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 .
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
See attached example.
Thanks Gysbert for the time and help !
The NName is coming blank for CName (A/D),rest looks good .
Regards,
Gargi
Hmm, ok, second attempt.
Looks good ! will check with my application and get back to you .
Thanks,
Gargi