topic Re: Is there a better way to implent pick wildmatch? in App Development

Is there a better way to implement pick wildmatch?

kwl1234 — Fri, 07 May 2021 08:59:15 GMT

expression:

Pick(wildmatch(Company),'A', 'B', 'C'),

Sum({Company = 'A'} Sales),

Sum({Company = 'B'} Sales),

Sum({Company = 'C'} Sales)

)

but I don't want to copy the formula 3 times and replace the filter Company = 'A', Company = 'B'......

Is there any better way to implement the expression above?

Can Qlik possible save the formula on variable and call back the variable on expression?

Re: Is there a better way to implent pick wildmatch?

tresB — Fri, 07 May 2021 08:59:15 GMT

In wildmatch() you have to include wildcard characters, like'*' - that is missing in your example.

It seems to be a unnecessary complexity in expression. If you have Company as dimension, you could simply use Sum(Sales) as expression. It does the same thing.

Re: Is there a better way to implent pick wildmatch?

kwl1234 — Fri, 07 May 2021 09:18:01 GMT

Hi tresesco,

The Actual formula is quite complex and

I really want make filter criteria dynamic on expression instead of using pick and match function. But I cannot find a way to do this.

Re: Is there a better way to implent pick wildmatch?

bramkn — Fri, 07 May 2021 09:30:20 GMT

Please post the formula then. As the example given is too simple to give any good advice on this.