topic getselections() in QlikView

getselections()

Tue, 27 Mar 2012 17:58:14 GMT

Hi All,

How we can check if a number or string exists in a return of a getselections() .

Here is what I want :

if 3 exists in getselections(PERIOD)

Thanks

Tue, 27 Mar 2012 18:00:18 GMT

try wildmatch(getselections(PERIOD),'*3*')

Tue, 27 Mar 2012 18:02:13 GMT

Thanks, it worked

Tue, 27 Mar 2012 18:10:56 GMT

There is a problem here.

It shows 11 and 12 when I select 10 .

Do you have any idea?

Tue, 27 Mar 2012 18:12:10 GMT

Can you upload a sample with the issue you are getting?

Also see if you have the same issues using GetFieldSelections(Period)

Tue, 27 Mar 2012 18:17:55 GMT

The document is big and I can't upload.

for the getselections() is ok but with wildmatch it goes wrong.

Thanks

Tue, 27 Mar 2012 18:26:18 GMT

It's fixed now. I removed the * when the period is 1 ,2 and it's good now.

Thanks.

Tue, 27 Mar 2012 18:30:41 GMT

Another option would be to just use the match function if you are looking to match exactly.