topic Re: (selected/total) in caption in QlikView

(selected/total) in caption

aytacbas — Fri, 17 Oct 2014 16:29:54 GMT

Hi;

I want to see how many selected from total

for example I have 51 product but I selected only 2

product quantity = (2/51)

Thanks

Re: (selected/total) in caption

Anonymous — Fri, 17 Oct 2014 16:34:58 GMT

If you want to show it on a text object, you can use something like this expression:

='Products Selected: ' & GetSelectedCount(ProductField) & '/' & count({<ProductField=>}DISTINCT ProductField)

Hope it helps.

Gabriel

Edited:

You can also use this same expression in the caption of your list Box.

Re: (selected/total) in caption

aytacbas — Fri, 17 Oct 2014 18:25:08 GMT

Thanks but it doesn't work correctly,

when ı select 2 item it shows (0/2) not (2/51)

Re: (selected/total) in caption

JonnyPoole — Fri, 17 Oct 2014 18:27:48 GMT

I suggest

= count( distinct ProductField) & ' /. ' & count ( {1} distinct ProductField)

The {1} will show the grand total no matter what selections a user made. Also i suggest count so that a user will know what the 'possible' products there are in their current selections , not just the products they directly selected.

Re: Re: (selected/total) in caption

Anonymous — Fri, 17 Oct 2014 18:33:27 GMT

Take a look on the attached file.

Regards,

Gabriel

Re: (selected/total) in caption

aytacbas — Sat, 18 Oct 2014 07:28:00 GMT

ıt worked. I complete succesfully

THANKS

Re: (selected/total) in caption

JonnyPoole — Sat, 18 Oct 2014 12:55:58 GMT

Super. Can you close the thread with helpful/correct answers?