topic Re: Calculated dimension including if condition in QlikView

Calculated dimension including if condition

Thu, 21 Jun 2012 09:24:42 GMT

Hi,

I need to write a calculated dimension which includes many if conditions.

What I want is to see data in Field I in dimension column if the calculated value(in if condition below) is smaller than or equal to 0.58.

However I get an 'error in calculated dimension'.

What is wrong, please advise...

=if(

((((if(

(sum({ <[Field A]={50}>} [Field B])

sum({ <[Field A]={50}>} [Field C])) > 2, 2, (sum({ <[Field A]={50}>} [Field B])

sum({ <[Field A]={50}>} [Field C]))

))

(if(

(sum({ <[Field A]={50}>} [Field D])

sum({ <[Field A]={50}>} [Field E])) > 2, 2, (sum({ <[Field A]={50}>} [Field D])

sum({ <[Field A]={50}>} [Field E]))

))

(if(

(sum({ <[Field A]={50}>} [Field F])

sum({ <[Field A]={50}>} [Field G])) > 2, 2, (sum({ <[Field A]={50}>} [Field F])

sum({ <[Field A]={50}>} [Field G]))

)))/3)

(avg({ <[Field A]={50}>} Field H)))

<= 0.58 , [Field I])

Re: Calculated dimension including if condition

lironbaram — Thu, 21 Jun 2012 10:17:05 GMT

change to

=aggr(if(

((((if(

(sum({ <[Field A]={50}>} [Field B])

sum({ <[Field A]={50}>} [Field C])) > 2, 2, (sum({ <[Field A]={50}>} [Field B])

sum({ <[Field A]={50}>} [Field C]))

))

(if(

(sum({ <[Field A]={50}>} [Field D])

sum({ <[Field A]={50}>} [Field E])) > 2, 2, (sum({ <[Field A]={50}>} [Field D])

sum({ <[Field A]={50}>} [Field E]))

))

(if(

(sum({ <[Field A]={50}>} [Field F])

sum({ <[Field A]={50}>} [Field G])) > 2, 2, (sum({ <[Field A]={50}>} [Field F])

sum({ <[Field A]={50}>} [Field G]))

)))/3)

(avg({ <[Field A]={50}>} Field H)))

<= 0.58 , [Field I]) , [Field I])

Re: Calculated dimension including if condition

Thu, 21 Jun 2012 10:55:27 GMT

it works perfectly, thank u!

I need your help for another problem. now I need to add one more constraint for the same table:

if( [Field X]<= 6 and [Field A]= 80, [Field I] )

I could not combine this with the above.

Any idea?