topic create derived var in QlikView https://community.qlik.com/t5/QlikView/create-derived-var/m-p/226462#M78665 <HTML><HEAD></HEAD><BODY><P>Hi, I am pretty new to qlikview, assume I have a dataset like this:</P><P>grp,var1<BR />a,0<BR />a,1<BR />a,0<BR />b,1<BR />b,1<BR />b,0<BR />b,0<BR />b,0<BR />c,0<BR />c,1<BR />c,1</P><P>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?</P><P>Thanks in advance</P><P>Shiping</P></BODY></HTML> Thu, 21 Apr 2011 18:13:54 GMT 2011-04-21T18:13:54Z create derived var https://community.qlik.com/t5/QlikView/create-derived-var/m-p/226462#M78665 <HTML><HEAD></HEAD><BODY><P>Hi, I am pretty new to qlikview, assume I have a dataset like this:</P><P>grp,var1<BR />a,0<BR />a,1<BR />a,0<BR />b,1<BR />b,1<BR />b,0<BR />b,0<BR />b,0<BR />c,0<BR />c,1<BR />c,1</P><P>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?</P><P>Thanks in advance</P><P>Shiping</P></BODY></HTML> Thu, 21 Apr 2011 18:13:54 GMT https://community.qlik.com/t5/QlikView/create-derived-var/m-p/226462#M78665 2011-04-21T18:13:54Z create derived var https://community.qlik.com/t5/QlikView/create-derived-var/m-p/226463#M78666 <HTML><HEAD></HEAD><BODY><P>Hi Shiping,</P><P></P><P>Try a chart using 'grp' as dimension, and the average of 'var1' (that is: avg(var1) ) as the expression.</P><P></P><P>regards,</P><P>Martijn ter Schegget</P><P>The Implementation Group</P><P></P></BODY></HTML> Fri, 22 Apr 2011 11:45:14 GMT https://community.qlik.com/t5/QlikView/create-derived-var/m-p/226463#M78666 2011-04-22T11:45:14Z