Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
Creator II

Selections from an expression in a list box

Hi.

When I write an expression in a list box using a wildmatch, I get both 'MonthYear' and 'Item' selected.

I expected to have just 'MonthYear' selected.

How can I rearrange the below formula to have just MonthYear selected, it messed up my whole sheet.

if(wildmatch([Data group],'*Item*'),MonthYear)

Thanks.

3 Replies
Anonymous
Not applicable

can we do sth like this?

if([Data group] like '*Item*',MonthYear)

tinkerz1
Creator II
Creator II
Author

Hi thanks, but Data Group is still selecting 'Item

'

SergeyMak
Partner Ambassador
Partner Ambassador

Hi Neil,

Could you please clarify your logic? Why do you need this "quite strange" from my point of view behaviour?

Regards,

Sergey

P.S.: You can create a separate field in load script eg YearMonth1 and use it in listbox:

if(wildmatch([Data group],'*Item*'),MonthYear) as YearMonth1

Regards,
Sergey