Calculating a simple percentage

[#1]

Dear All,

  Please can any one solve my problem, as i am beginner to qlikview and have very little concept of expression and calculated fields in qlikview.

I have a below table under review,

Student_ID  Class_Room

A                    555

B                    666

C

D

E

can any one tell me the expression which shows % student in two classes.. ?

[Or]

It's a little difficult to understand what you're trying to do, but if you're looking for a straight percentage, and assuming this is a chart object with Class_Room as a dimension, your expression would be:

count(Student_ID) / Count(Total Student_ID)

If this isn't what you meant, try and provide a clearer example of what you're trying to do and what your expected outcome is.

[#3]

well, if you want to show this percentage in a graph, choose your normal expressions, and select an option on the expressions tab called "Relative", I think that might help you.

[senpradip007]

Hi,

Please provide example as your question is not so clear.

[#5]

I was trying to explain an abstract of my problem to you all.

Let me explain it again, I hope would help u to get my problem root cause.

i have two fields Student_ID which contains alphabets only in respective rows e.g. A, B, C , D are names of  students.

another field is Class_Room to which these student belongs.

now qlikview do permit me to count the student as I input expression Count(Student_ID), but I am unable to calculate relative percentage of these students to each class.

Hope would give u better picture now.

[#6]

did you try to solve it doing what I said?

[#7]

I tried but its not working in my case jo !

[Anonymous]

Hi,

do exactly as is say.

1. create a straight table.

2. add your dimension ClassRoom in Dimension tab.

3. add your expression  count(Student_Id) if you click ok you will see count of students in each class.

4. But you require Relative percent so its simple go back to expression tab just check Relative Check

    box  click  ok you will see now values as percent .

Regards,

anant

[#9]

Why do you have two fields of Student_ID ?

A Student can only be in one or several classes ?

if a Stunden can only be in one class, try this:

num(1 / aggr(count(all Student_ID),Class_Room),'#.##0,00%')

if it displays the numbers wrong try it with *100

num(1 / aggr(count(all Student_ID),Class_Room)*100,'#.##0,00%')

you could also display this data in a pivot table with Class_Room  as the first dimension and Student_ID as the second dimension. I thinks this would be better so understand which Student belongs to which class.

[Anonymous]

Great!

I did that and it works!