Average syntax need help...

[#1]

Dear All,

Hi, im new to qlikview so im not familiar with the expression. Im doing a grade distribution project. I need help with the expression.

objective is to get the average percentage of modules or courses grade 'A'.

Criteria:

1.Average of Modules or Courses more than 30% grade 'A'

2.Average of Modules or Courses more than 40% grade 'A'

3.Average of Modules or Courses more than 60% grade 'A' and 'B'

4.Average of Modules or Courses less than 10% grade 'A'

The expression i currently have is this for all charts:

=count(if(Num#(A,'#.##%') > Num#('30%','#.#%'), 1)) / count(A)

The chart should show average of module or courses grade 'A' more than 30%, but im not sure of the average syntax expression to use.

Thank you for your help .

I will attach a sample app and the data from excel spreadsheet:

[lironbaram · Accepted solution]

hi

have a look at the attach example

if i understood your requirement then it should help

[rubenmarin]

Hi, check attachment.

Hope this helps

[#4]

hi,

your expression work for me thank you..

[#5]

hi...

thank you for the help..your expression was useful too

[#6]

i need help again..

i have a problem with this new criteria:

1. I have to view Average of Modules and Courses more than 30% grade 'A'  by Semester

    -'2012 Sem 1'

    -'2012 Sem 2'

    -'2013 Sem 1'

Im not sure how to do it. Do I need to add in a second dimesion or do i need to create an expression?

this is not an expression but this i what i can come up with at the moment:

if average Module_Code = ' ' From Semester = '2012 Sem 1' More Than 30% A

or

average(if(Module_Code = '  ' From Semester ='2012 Sem 1' More Than 30% A

i've attached a sample app and data from excel spreadsheet

Thank you once again....

[lironbaram]

hi

have a look at the attach example

added a pivot table that display the data for each module in each simister