Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
Please post the formula then. As the example given is too simple to give any good advice on this.