topic Re: Selections from an expression in a list box in QlikView

Selections from an expression in a list box

tinkerz1 — Tue, 17 Nov 2015 09:53:29 GMT

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.

Anonymous — Tue, 17 Nov 2015 09:58:36 GMT

can we do sth like this?

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

tinkerz1 — Tue, 17 Nov 2015 10:07:54 GMT

Hi thanks, but Data Group is still selecting 'Item

SergeyMak — Tue, 17 Nov 2015 10:55:44 GMT

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