topic Re: calculate dimension in QlikView

calculate dimension

kkarlste — Wed, 29 Aug 2018 10:12:00 GMT

have you any ideas this calculation dimension

how the script goes

if field1 = ('1','10) sum (field2 /0,85) otherwise take (field3)

if field4 = ('9225', '9153', '9161', '9122', '9104') field1 = ('1','10) sum (field2 / 0,9) otherwise take (field3)

Re: calculate dimension

thevingo — Wed, 29 Aug 2018 10:16:33 GMT

If( field1 =1 or field1 =10, sum (field2 /0.85), field3)

if ( match(field4 , '9225', '9153', '9161', '9122', '9104') and match(field1 , 1, 10), sum (field2 / 0.9), field3)

Re: calculate dimension

kkarlste — Wed, 29 Aug 2018 10:34:54 GMT

This is correct

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

but this is not

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

Re: calculate dimension

sewialwork — Wed, 29 Aug 2018 11:13:51 GMT

You forgot to close your sum. Try this:

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

AGB

Re: calculate dimension

sunny_talwar — Wed, 29 Aug 2018 11:19:45 GMT

Check here

calculate dimension

Re: calculate dimension

kkarlste — Wed, 29 Aug 2018 11:38:19 GMT

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

if you this thig (sum

bold text not works

Re: calculate dimension

BalaBhaskar_Qlik — Wed, 29 Aug 2018 14:12:02 GMT

You were not closed the bracket of Tuottovarattavat='x' properly.'

Use below expression:

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

Re: calculate dimension

neelamsaroha157 — Wed, 29 Aug 2018 14:15:11 GMT

In order to use an aggregation function like Sum in calculated dimension, you'll need to use Aggr -

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

(Check on the number of paranthesis)

Re: calculate dimension

BalaBhaskar_Qlik — Wed, 29 Aug 2018 14:16:38 GMT

=If(Match(field1,'1','10'),Sum(field2/0.85),field3)

=if(Match(field4,'9225','9153','9161','9122','9104') and Match(field1,'1','10'),Sum(field2/0.9),field3)

Re: calculate dimension

kkarlste — Wed, 29 Aug 2018 18:55:27 GMT

Correct answer

Re: calculate dimension

BalaBhaskar_Qlik — Thu, 30 Aug 2018 05:06:46 GMT

If you got the Answer, please close thread by marking it as Answered.