topic Display numbers in QlikView

Display numbers

kicchu465 — Wed, 25 Nov 2020 16:16:04 GMT

hi all,

I have a small doubt,

i have texbox with the expression

=count(ID) is 20

but i want that 20 details information in table box

how can i achieve this>

Thanks

Re: Display numbers

sunny_talwar — Fri, 27 Oct 2017 16:39:22 GMT

Create a table box with the fields you want to see + ID... and you should be able to see all the unique combination of your dimensions.... If you know there are duplicates and your still want to see all of them...then create a new field in the script like this

RecNo() as RowNum

and then add this as one of the dimensions of your table box