topic Re: Calculating a simple percentage in QlikView

Calculating a simple percentage

Tue, 03 Sep 2013 12:13:20 GMT

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

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

Re: Calculating a simple percentage

Or — Tue, 03 Sep 2013 12:26:52 GMT

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.

Re: Calculating a simple percentage

Tue, 03 Sep 2013 12:31:05 GMT

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.

Re: Calculating a simple percentage

senpradip007 — Tue, 03 Sep 2013 12:40:50 GMT

Hi,

Please provide example as your question is not so clear.

Re: Calculating a simple percentage

Tue, 03 Sep 2013 13:17:20 GMT

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.

Re: Calculating a simple percentage

Tue, 03 Sep 2013 13:27:22 GMT

did you try to solve it doing what I said?

Re: Calculating a simple percentage

Wed, 04 Sep 2013 06:48:55 GMT

I tried but its not working in my case jo !

Re: Calculating a simple percentage

Anonymous — Wed, 04 Sep 2013 07:02:45 GMT

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

Re: Calculating a simple percentage

Wed, 04 Sep 2013 07:20:19 GMT

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.

Re: Calculating a simple percentage

Anonymous — Tue, 17 Nov 2015 10:31:07 GMT

Great!

I did that and it works!

Re: Calculating a simple percentage

Tue, 24 May 2016 13:05:09 GMT

Try This on the Expressions Tab:

(sum ([Class_Room]) / count (total [Student_ID]))