topic Field value in a expression in QlikView

Field value in a expression

dbouilleux1 — Thu, 04 Aug 2011 19:10:50 GMT

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.

Re: Field value in a expression

johnw — Thu, 04 Aug 2011 22:01:14 GMT

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:

http://community.qlik.com/docs/DOC-1335

Field value in a expression

dbouilleux1 — Fri, 05 Aug 2011 06:20:02 GMT

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