Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

getselections()

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

Labels (1)
1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

7 Replies
Not applicable
Author

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

Not applicable
Author

Thanks, it worked

Not applicable
Author

There is a problem here.

It shows 11 and 12 when  I select 10 .

Do you have any idea?

Not applicable
Author

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

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

Not applicable
Author

The document is big and I can't upload.

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

Thanks

Not applicable
Author

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

Thanks.

Not applicable
Author

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