ratio calculation

[#1]

Hi every one. I am new in Qlik and want to ask a question. I have a set of data with 5 variable. one of them is school name. In this variable how can I calculate ratio of one school vs all others.

[Anonymous]

okay,

Is this right?

=Sum({<School={'Nursing'}>} Score) / Sum(Score)

[sunny_talwar]

Yup

[Anonymous]

Thank God!!!!

I was thinking you would again come with some different comments, but at the end all is well

[sunny_talwar]

I was in a mood to learn something new here

[Anonymous]

Ohh..for your learning,

I was trying to say like this..

see the attachment

[sunny_talwar]

This is different then the above. In the above you are using Set analysis in the numerator and hence to find the TOTAL you don't need TOTAL, you just leave out the set analysis. In the attached example you don't have any set analysis in the numerator and hence you needed TOTAL to get the total (in addition I did use total when I used this in a straight table)

"and if you are doing this in a straight table with schoolname as your dimension, then try this:

=Count(schoolname)/Count(TOTAL schoolname) "

[Anonymous]

okay, Got it.

Lets close it