IF and OR in calculated dimension

Wed, 07 Oct 2015 12:09:28 GMT

Hello all,

=if((if((KREDIT/100)=0 OR
(DEBET/100)=0 OR
((sum(if(NUMBERDRIVE>=1,((KREDIT/100)-(DEBET/100)))))/(sum((KREDIT/100))))>=0.25 OR
((sum(if(NUMBERDRIVE>=1,((KREDIT/100)-(DEBET/100)))))/(sum((KREDIT/100))))<=-0.25,((NAME)),null())
)>='a',NUMBER,null())

This calculated dimension in my standard table give as answer: mistake. How is that possible and is there somebody who can helps me?

Best regards, Li

Re: IF and OR in calculated dimension

hic — Wed, 07 Oct 2015 14:30:33 GMT

Because it is not well defined. You have a mix of naked field references and aggregations and it is not well defined how these should be calculated. Should the summation be made per transaction, per account, per month or per cost center? Compare with a SQL GROUP BY.

The solution is to use an Aggr() function, where you define your grouping symbols and your aggregations separately:

=Aggr(<expression>, TransactionID)

or something similar.

See Calculated Dimensions

Pitfalls of the Aggr function

HIC

topic IF and OR in calculated dimension in QlikView

IF and OR in calculated dimension

Re: IF and OR in calculated dimension