Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
josephinetedesc
Creator III
Creator III

set analysis expression and plain aritmentic

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))

Jo

1 Solution

Accepted Solutions
sunny_talwar

May be this:

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

View solution in original post

3 Replies
sunny_talwar

May be this:

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

josephinetedesc
Creator III
Creator III
Author

Thank you

Sunny T!

Happy New Year

sunny_talwar

Thank you and same to you