topic List Object- How to count the options selected? in QlikView

List Object- How to count the options selected?

Wed, 20 Jan 2010 14:54:31 GMT

Hi everyone!

I'm here this time because I've a list object of the months of the year & for a calculation (an expression in a table) I need to know how many months were selected of the list mentioned.

I tried to use the name of the field (Month) but it doesn't return me what I'm expecting.

Then, how can I know how many month were selected?? so far, I'm not interested in know wich months.

Thxs in advance!

List Object- How to count the options selected?

Wed, 20 Jan 2010 15:03:42 GMT

Use GetSelectedCount(Month)

Andris

List Object- How to count the options selected?

Wed, 20 Jan 2010 17:10:06 GMT

Hi Adris, thxs 4 answer.

I tried, but it returns -

I dont know if is because the field Month its a key field, could that be?

List Object- How to count the options selected?

mike_garcia — Wed, 20 Jan 2010 17:23:05 GMT

If you take a look at the example file called [Photo and Music], you'll notice that on the sheet Music there are several list boxes that have the count of selected items.

In this example, the function 'Count' is being used. So you can just write an expression like:

count(Distinct Month)

Now, if no selections are made, this will return the TOTAL number of distint items, when maybe what you want is zero. So, you can use an if statement that determines if something is selected or not:

if(isnull(GetFieldSelections(Month)),0,count(Distinct Month))

Hope this helps.

Mike.

List Object- How to count the options selected?

Wed, 20 Jan 2010 17:33:59 GMT

Hi Mike,

I just did what you recommend me, and Thxs! It works..!

I'd tried count without distinct and descarted the idea!!

Thxs!

Re: List Object- How to count the options selected?

aeAndi — Fri, 29 May 2020 08:21:20 GMT

Thanks, GetSelectedCount worked good 🙂