topic List box selection calculation in Caption in QlikView

List box selection calculation in Caption

Sat, 23 Aug 2014 21:08:02 GMT

I have a Customers List box. There are 92 customers. In the title the display should be "Customers = 92/92". If I select 3 customers then the display should change to "Customers = 3/92". Can anybody please let me know how to display?

Re: List box selection calculation in Caption

nagaiank — Sat, 23 Aug 2014 22:32:59 GMT

Use the expression

=GetSelectedCount(customer) & '/' & Count({1<customer=>}distinct customer)

for the title in the List box Properties Window -> General tab

Re: List box selection calculation in Caption

Sat, 23 Aug 2014 22:48:54 GMT

This expression should work too:

=Count(Distinct customer) & '/' & Count({1} Distinct customer)

Re: List box selection calculation in Caption

MarcoWedel — Sat, 23 Aug 2014 23:39:43 GMT

Hi,

another one:

hope this helps

regards

Marco