topic Formula use in set analysis in QlikView

Formula use in set analysis

Thu, 16 Sep 2010 14:47:05 GMT

Hi Guys,

I have a set analysis sample here

=Count({$< vAverageScore = {">= 0 <= 25"}>} Distinct Student)

Where: vAverage is an Expression ; vAverage = avg(StudentScore)

This set analysis should count the number of student with an average is from 0 to 25.

Is this possible? Coz in my workfile the result is just the distinct count of Student. (the expression ignores the " vAverageScore = {">= 0 <= 25"" part)

Thanks

Formula use in set analysis

Thu, 16 Sep 2010 15:02:28 GMT

I´m not sure.....but you can not use expression(vAverageScore) to compare in your set!!!!!!

You must use just Dimensions!!!!!

Formula use in set analysis

tabletuner — Thu, 16 Sep 2010 15:02:55 GMT

Hi,

is this syntax helpful:

=Count({$< vAverageScore ={$(='">=' & 0 &'<=' & 25 &'"' )} Distinct Student)

Regards,

Tjeerd

Formula use in set analysis

johnw — Thu, 16 Sep 2010 21:27:14 GMT

As Érico says, you can't do set analysis using a variable or expression like that. You can only use set analysis on fields. So the trick is figuring out how to do this using fields. And the trick to that is realizing that you can use advanced search features. Untested, but I think it would look something like this:

count({<Student={"=avg(StudentScore)>=0 and avg(StudentScore)<=25"}>} Student)