Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
josephinetedesc
Contributor 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

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: set analysis expression and plain aritmentic

May be this:

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

View solution in original post

3 Replies
Highlighted

Re: set analysis expression and plain aritmentic

May be this:

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

View solution in original post

Highlighted
josephinetedesc
Contributor III

Re: set analysis expression and plain aritmentic

Thank you

Sunny T!

Happy New Year

Highlighted

Re: set analysis expression and plain aritmentic

Thank you and same to you