Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Try using the set analysis before the if:
Avg({<OperationOrder={1}, CancelledOnDay={0}>} If(Session='AM', MinAnaesthetistStart))
Try using the set analysis before the if:
Avg({<OperationOrder={1}, CancelledOnDay={0}>} If(Session='AM', MinAnaesthetistStart))
try with:
avg({<OperationOrder={1}>} {<CancelledOnDay={0}>} if(Session='AM',MinAnaesthetistStart))
you can also try like this :
if(Session='AM',avg({<OperationOrder={1}>} {<CancelledOnDay={0}>} MinAnaesthetistStart))
Thanks you works perfect!
i just got it all the wrong way round, simple hey, yet seems backwards.
big leanring curve this Qlikview thanks
Thanks you works perfect!
i just got it all the wrong way round, simple hey, yet seems backwards.
big leanring curve this Qlikview thanks
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
No problem.
I am glad I was able to help.
Best,
Sunny
Wellcome in this wonderful Group!
Please close this thread by marking the correct answer