Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

dbouilleux
New Contributor

Field value in a expression

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.

2 Replies
MVP
MVP

Re: Field value in a expression

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

dbouilleux
New Contributor

Field value in a expression

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

Community Browser