Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
theboss-123
Creator II
Creator II

Displaying value

hi i have a question :

 

i have a table which display below data this is an example 

 

Ref                               Quantity

A                                    4

B                                    4

C                                    4

 

but Qlikview display just one row in QUantity is there any tips or workarround for this case ?

A                                                4

B

C

1 Solution

Accepted Solutions
mfchmielowski
Creator II
Creator II

As i see on screenshot you're using only listbox objects.

Try to create table object with columns:

Piece, Qte, Ref, Designation, Site

I think that this will allow you to investigate the data. 

View solution in original post

5 Replies
edwin
Master II
Master II

are you using a table or chart?  post your expression.  that may be where the issue is.  if you are using aggr, add a NODISTINCT as ive seen this scenario with AGGRs

mfchmielowski
Creator II
Creator II

Hi.

If you load table from the example:

Sample:
load * inline [
  Ref, Quantity
  A, 4
  B, 4
  C, 4
];

Then the Table object will show you the full table of all distinct values. But the listbox objects will show:

Ref:
A
B
C

Quantity
4

As available values for selection. 

theboss-123
Creator II
Creator II
Author

i did load *inline allways the same resulst for example i uploader a screenshoot i can't know which ligne has 40 or 20

im a biguinner in qlikview

mfchmielowski
Creator II
Creator II

As i see on screenshot you're using only listbox objects.

Try to create table object with columns:

Piece, Qte, Ref, Designation, Site

I think that this will allow you to investigate the data. 

theboss-123
Creator II
Creator II
Author

Hi  you are right the table arrange very well data thank you