topic GetFieldSelections with Multiple selections in QlikView

GetFieldSelections with Multiple selections

danielact — Thu, 24 May 2012 12:44:37 GMT

Is there a way to check if an item is selected when you've selected multiple items in the field?

For example, let's I have a field with values 1-10. I know that if I only have one selection made, I can use GetFieldSelection. If I want to see if 4 was selected, I can use if(GetFieldSelections(num)=4,True)

What if I've selected values 1,2,3,4,5? I can't use the same logic. Is there anything I can use to see if 4 was selected?

GetFieldSelections with Multiple selections

jvitantonio — Thu, 24 May 2012 13:00:46 GMT

Hi, use this:

=if(findoneof(GetCurrentSelections(yourField),'4')>0, 'true','false')

GetFieldSelections with Multiple selections

CELAMBARASAN — Thu, 24 May 2012 13:01:41 GMT

Hi,

Use SubStringCount() or WildMatch()

if(SubStringCount(GetFieldSelections(num,'|'),'4')>0,1)

if(WildMatch(4,$(=GetFieldSelections(num,','))),1)

GetFieldSelections with Multiple selections

danielact — Thu, 24 May 2012 13:10:34 GMT

SubStringCount seems to be doing what I want, but I still have a small problem. In the example I gave, there was only a small data set. In my actual data, there are many more values, and there might be a large amount of selections. In GetFieldSelections, when you get above a certain number of selections, it doesn't list each one - it might say '20 of 300'. Is there a way to make it give the full list?

GetFieldSelections with Multiple selections

CELAMBARASAN — Thu, 24 May 2012 13:15:00 GMT

Hi,

Yes.Then you have to specify the max number of selections

GetFieldSelections(num,'|',100) here i assumed you have list box with 100 values.

Celambarasan

GetFieldSelections with Multiple selections

Thu, 24 May 2012 13:21:11 GMT

Hi,

try this:

getselectedcount(YOURFIELD)

it gives you the number of field selected.