topic Re: Re: Re: Average syntax need help... in QlikView

Average syntax need help...

Tue, 18 Nov 2014 07:04:16 GMT

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:

Re: Average syntax need help...

lironbaram — Tue, 18 Nov 2014 07:18:24 GMT

have a look at the attach example

if i understood your requirement then it should help

Re: Average syntax need help...

rubenmarin — Tue, 18 Nov 2014 08:09:56 GMT

Hi, check attachment.

Hope this helps

Re: Average syntax need help...

Sat, 22 Nov 2014 18:50:19 GMT

hi,

your expression work for me thank you..

Re: Average syntax need help...

Sat, 22 Nov 2014 18:52:55 GMT

hi...

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

Re: Re: Average syntax need help...

Sat, 22 Nov 2014 19:11:43 GMT

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

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....

Re: Re: Re: Average syntax need help...

lironbaram — Mon, 24 Nov 2014 13:29:12 GMT

have a look at the attach example

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