create derived var

[#1]

Hi, I am pretty new to qlikview, assume I have a dataset like this:

grp,var1
a,0
a,1
a,0
b,1
b,1
b,0
b,0
b,0
c,0
c,1
c,1

which method I should use, edit expression, macro, func to get each grp rate(a:.33, b:.4, c:.67)? Can some one give me an example for each method?

Thanks in advance

Shiping

[#2]

Hi Shiping,

Try a chart using 'grp' as dimension, and the average of 'var1' (that is: avg(var1) ) as the expression.

regards,

Martijn ter Schegget

The Implementation Group