Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show no of times student presence in pie chart?

Hi,

I have chart in qvw with StudentID, StaffID, Department, [Exam Date], [Record Date],[No of times Student presence].

the values in column [No of times Student presence] are as shown below

4,9,8,2,1,1,1,1,1,3,3,3,3,5,5,5,5,7,7,7,10,0,34,90,100,21,24

the expression used under [No of times Student presence] is Count(StudentID)

The sample data in chart is as below

                                                                                                                                                          

StudentIDStaffIDDepartmentExam DateRecord DateNo of times   student Presence
00Physics27/02/201104/03/201124
012Physics27/02/201104/03/201152
012Accounts02/03/201503/03/20155
89009712Chemistry27/02/201527/02/20151
55353635212Physics02/03/201502/03/20151
93253437612Chemistry03/03/201503/03/20151
15246498612Chemistry03/03/201503/03/20151
1706647720Chemistry02/03/201504/03/20154
1827543320Maths03/03/201504/03/20152
18275433212Chemistry02/03/201504/03/20152
9048564840Maths02/03/201503/03/20153
4895477040Chemistry02/03/201003/03/20103

I need to show a pie chart to show the number of times student presence be represented in a graph for example 300 Students, of which 25 are presence to once, 25 are presence to twice and 100 are presence to three times

Please can anyone help me in this.

Thanks.

10 Replies
pauljohansson
Creator III
Creator III

Hi,

Have your tried using a calculated dimension like:

=aggr(sum([No of times   student Presence]), StudentID)

with the expression


count(StudentID)

br

Paul

Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks. the data which I added in my original post is just 11 rows data. But I have millions of data in excel file.

how I need to use Count(StudentID) to show as pie chart

Not applicable
Author

any suggestions please?

c_gilbert
Creator II
Creator II

If you want to show the pie chart as percentages, just click the 'relative' checkbox in the expressions tab.

Not applicable
Author

Thanks. I tried it. Not working. Please any help.

Not applicable
Author

Thanks. Tried this. not showing exact result.

Roop
Specialist
Specialist

Very similar to Gysbert's example above ....

example.png

Main difference being using a percentage scale.

Hopefully this helps

Not applicable
Author

Thanks. you added dimension student presence.

But this student presence have values which is getting from below expression.

Count(StudentID)

so, my requirement is dimension and expression both are same.

is it possible to use expression count(StudentID) for both Dimension and Expression.

Please help me. when I am trying I am not getting exact solution.