topic Re: Displaying value in QlikView

Displaying value

theboss-123 — Thu, 07 Jan 2021 16:33:09 GMT

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

Re: Displaying value

edwin — Thu, 07 Jan 2021 16:59:02 GMT

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

Re: Displaying value

mfchmielowski — Thu, 07 Jan 2021 17:01:15 GMT

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.

Re: Displaying value

theboss-123 — Thu, 07 Jan 2021 17:15:36 GMT

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

Re: Displaying value

mfchmielowski — Thu, 07 Jan 2021 17:20:20 GMT

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.

Re: Displaying value

theboss-123 — Thu, 07 Jan 2021 18:50:05 GMT

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