Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am a new user in qlik sense.
when I separate set this expression, it doesn't have any problem
Sum({$<[TXDATE.autoCalendar.MonthsAgo]={"1"}>}PROMOSALESQTY)
I set the below wildmatch on selection box, that's also no problem
=if(wildmatch(XF_REMARK,'*crazysales*'),'crazysales,'general promotion')
but how can I combine them, if I don't want to use selection box?
I want directly the "PROMOSALESQTY" in each month (past 12 months) only show the crazy sales qty?
Thanks a lot!
It's works now. Thanks a lot.
I try yours similar before but I write XF_REMARK={'*crazysales*'} that didn't work.
Just wonder, in what situation by using " & ' ?
single quotes are for literal string (i.e. exact matches) not searches.
in this case you should use " even though the single quotes work.
if i recall correctly its a bug (even though it works).
Not 100% on the latest status of this
see below from @hic
https://community.qlik.com/t5/Qlik-Design-Blog/Quotes-in-Set-Analysis/ba-p/1471824#comments
The bug was fixed in the November 2018 release.
So, now the behaviour is the following:
XF_REMARK={"*crazysales*"} is a case insensitive search using a wildcard.
XF_REMARK={'*crazysales*'} is a case sensitive match with a string that is 12 characters long, and starts and ends with a '*' (char(42)).
HIC