Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Straight table

Hi All,

Facing some issue in showing data as required by user :

straight_table.jpg

Attaching the sample data for the same .

Help needed.

Thanks,

Gargi

8 Replies

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

MVP
MVP

PFA

1.png

Creator
Creator

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 :    

CNameVNameNNameVValNValTotal
A UUU0300300
AGG 2000200


Required is:


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

 

CNameVNameNNameVValNValTotal
AGGUUU200300500

Thanks again .

Creator
Creator

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

MVP & Luminary
MVP & Luminary

See attached example.


talk is cheap, supply exceeds demand
Creator
Creator

Thanks Gysbert for the time and help !

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

Regards,

Gargi

MVP & Luminary
MVP & Luminary

Hmm, ok, second attempt.


talk is cheap, supply exceeds demand
Creator
Creator

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

Thanks,

Gargi