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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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