Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
In one of my dimensions, I have a field named 'cr_Numero' which contains a piece of search string (eg {'72 *'}).
In a chart that uses this dimension, I would use the value of this field to calculate an expression for each element of this dimension (for example, and get Sum ({$ <* Number = {'72 '}>} Amount).
I can not set up the correct syntax.
Can anyone help me?
Sincerely,
Denis.
A set is evaluated once for the entire chart, not once per dimension value. So you can't do this with set analysis without some serious complexity to work around that limitation. It might be slow, but perhaps a sum(if())?
sum(if(wildmatch(Number,cr_Numero),Amount))
I believe you'd have to remove the {} brackets and single quotes. If that works, but is way too slow, only then would I even attempt the set analysis version:
So there are things you can not do with Qlikview!
I'm pretty disappointed ...
So I will change my approach to the problem.
thank you,
Sincerely,
Denis