# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for
Did you mean:
Highlighted
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

 StudentID StaffID Department Exam Date Record Date No of times   student Presence 0 0 Physics 27/02/2011 04/03/2011 24 0 12 Physics 27/02/2011 04/03/2011 52 0 12 Accounts 02/03/2015 03/03/2015 5 890097 12 Chemistry 27/02/2015 27/02/2015 1 553536352 12 Physics 02/03/2015 02/03/2015 1 932534376 12 Chemistry 03/03/2015 03/03/2015 1 152464986 12 Chemistry 03/03/2015 03/03/2015 1 170664772 0 Chemistry 02/03/2015 04/03/2015 4 182754332 0 Maths 03/03/2015 04/03/2015 2 182754332 12 Chemistry 02/03/2015 04/03/2015 2 904856484 0 Maths 02/03/2015 03/03/2015 3 489547704 0 Chemistry 02/03/2010 03/03/2010 3

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
Highlighted
Creator III

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

Hi,

Have your tried using a calculated dimension like:

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

with the expression

count(StudentID)

br

Paul

Highlighted
MVP & Luminary

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

See attached example.

talk is cheap, supply exceeds demand
Highlighted
Not applicable

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

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

Highlighted
Not applicable

Highlighted
Creator II

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

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

Highlighted
Not applicable

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

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

Highlighted
Not applicable

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

Thanks. Tried this. not showing exact result.

Highlighted
Specialist

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

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

Main difference being using a percentage scale.

Hopefully this helps

Highlighted
Not applicable

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

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.