what am I doin wrong? - expression

[qliklizzy]

Hi

i have this formula which works great until i add in a IF to it - what am i doing wrong?

thanks

avg({<OperationOrder={1}>} {<CancelledOnDay={0}>} MinAnaesthetistStart)

avg(if(Session='AM',{<OperationOrder={1}>} {<CancelledOnDay={0}>} MinAnaesthetistStart))

[sunny_talwar · Accepted solution]

Try using the set analysis before the if:

Avg({<OperationOrder={1}, CancelledOnDay={0}>} If(Session='AM', MinAnaesthetistStart))

[alexandros17]

try with:

avg({<OperationOrder={1}>} {<CancelledOnDay={0}>} if(Session='AM',MinAnaesthetistStart))

[avinashelite]

you can also try like this :

if(Session='AM',avg({<OperationOrder={1}>} {<CancelledOnDay={0}>} MinAnaesthetistStart))

[qliklizzy]

Thanks you works perfect!

i just got it all the wrong way round, simple hey, yet seems backwards.

big leanring curve this Qlikview thanks

[qliklizzy]

Thanks you works perfect!

i just got it all the wrong way round, simple hey, yet seems backwards.

big leanring curve this Qlikview thanks

[qliklizzy]

i did have it like this to start, but it woudlnt work so tried it that way and thought - im not understand this, i best ask the professionals

thanks for the reply

[sunny_talwar]

No problem.

I am glad I was able to help.

Best,

Sunny

[alexandros17]

Wellcome in this wonderful Group!

[sasiparupudi1]

Please close this thread by marking the correct answer