Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

gargi_bardhan
New Contributor III

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

Tags (1)
8 Replies

Re: Straight table

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

Re: Straight table

PFA

1.png

gargi_bardhan
New Contributor III

Re: 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)

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 .

gargi_bardhan
New Contributor III

Re: Straight table

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

See attached example.


talk is cheap, supply exceeds demand
gargi_bardhan
New Contributor III

Re: Straight table

Thanks Gysbert for the time and help !

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

Regards,

Gargi

Re: Straight table

Hmm, ok, second attempt.


talk is cheap, supply exceeds demand
gargi_bardhan
New Contributor III

Re: Straight table

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

Thanks,

Gargi

Community Browser