Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
kkarlste
Creator
Creator

calculate dimension

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)

2 Replies
sunny_talwar

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)

balabhaskarqlik

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)