topic set analysis expression and plain aritmentic in QlikView

set analysis expression and plain aritmentic

josephinetedesc — Wed, 30 Dec 2015 21:26:33 GMT

Hello

I use

Sum(DurMins)/Sum(AvailMins) - correct answer

sum(DurMins/AvailMins) - is not correct

Now I want to make the expression always respond to the choice of Classification = Clinical (without an if statement) and Set Analysis is perfect for this:

How do I write my set analysis ... I have not tried the wizard yet ...

sum({$<Classification = {'Clinical'}>}(DurMins/AvailMins))

Re: set analysis expression and plain aritmentic

sunny_talwar — Wed, 30 Dec 2015 21:30:04 GMT

May be this:

Sum({$<Classification = {'Clinical'}>}DurMins)/Sum({$<Classification = {'Clinical'}>}AvailMins)

Re: set analysis expression and plain aritmentic

josephinetedesc — Wed, 30 Dec 2015 21:32:58 GMT

Thank you

Sunny T!

Happy New Year

Re: set analysis expression and plain aritmentic

sunny_talwar — Wed, 30 Dec 2015 21:33:33 GMT

Thank you and same to you