topic Re: calculate dimension in QlikView

calculate dimension

kkarlste — Wed, 29 Aug 2018 10:52:37 GMT

This is correct

=If( Tuottovarattavat = 'x' , sum (Kulut /0.85), Veroton)

but this is not why? which is missing cutoff

if ( match( [VBAPFactKEY], '009225', '009153', '009161', '009122', '009104') and (Tuottovarattavat = 'x' , sum (Kulut / 0.9), Veroton)

sunny_talwar — Wed, 29 Aug 2018 11:18:49 GMT

Try this.. removed the extra opening parenthesis before Tuottovarattavat

If(Match([VBAPFactKEY], '009225', '009153', '009161', '009122', '009104') and Tuottovarattavat = 'x' , Sum(Kulut / 0.9), Veroton)

BalaBhaskar_Qlik — Wed, 29 Aug 2018 13:26:11 GMT

You were not closed the brackets properly,

if ( match( [VBAPFactKEY] '009225', '009153', '009161', '009122', '009104') and (Tuottovarattavat = 'x' , sum (Kulut / 0.9), Veroton)

In the above expression after and, you added one bracket, but not closed that properly.

Try below expression.

if ( match( [VBAPFactKEY], '009225', '009153', '009161', '009122', '009104') and (Tuottovarattavat = 'x') , sum (Kulut / 0.9), Veroton)