topic Formulas within Charts in QlikView https://community.qlik.com/t5/QlikView/Formulas-within-Charts/m-p/367668#M136720 <HTML><HEAD></HEAD><BODY><P>I am using a bar chart and want to calculate the percentage of an item.&nbsp; I am counting the number of occurances a particular field has and want to divide it be the number if Distinct effort numbers.&nbsp; The relationship is 1 to themes (many) to root cause (many).&nbsp; I am using demensions of theme and reporting year in the chart.&nbsp; The formula appears as Count ({$&lt;Rpt_Yr={$(vYear)}&gt;}Theme) / Count (distinct{$&lt;Rpt_Yr={$(vYear)}&gt;}Release_ID). I atttempted to use a variant of Count ({$&lt;Rpt_Yr={$(vYear)}&gt;}Theme) / Count (distinct{$&lt;Rpt_Yr={$(vYear)},Theme=&gt;}Release_ID). </P><P></P><P></P><P>Items to note:</P><P>list box for selection is Rpt_Yr and we limit this to only permit one choice, so we pass a parameter from this selection and calculate the second year for the variable vYear.&nbsp; vYear is 2012,2011.</P><P></P><P>If I use relativity, it would use all the rows and not give me the percentage of distinct projects impacted.&nbsp;&nbsp;&nbsp; </P><P></P><P></P></BODY></HTML> Thu, 24 May 2012 12:13:39 GMT 2012-05-24T12:13:39Z Formulas within Charts https://community.qlik.com/t5/QlikView/Formulas-within-Charts/m-p/367668#M136720 <HTML><HEAD></HEAD><BODY><P>I am using a bar chart and want to calculate the percentage of an item.&nbsp; I am counting the number of occurances a particular field has and want to divide it be the number if Distinct effort numbers.&nbsp; The relationship is 1 to themes (many) to root cause (many).&nbsp; I am using demensions of theme and reporting year in the chart.&nbsp; The formula appears as Count ({$&lt;Rpt_Yr={$(vYear)}&gt;}Theme) / Count (distinct{$&lt;Rpt_Yr={$(vYear)}&gt;}Release_ID). I atttempted to use a variant of Count ({$&lt;Rpt_Yr={$(vYear)}&gt;}Theme) / Count (distinct{$&lt;Rpt_Yr={$(vYear)},Theme=&gt;}Release_ID). </P><P></P><P></P><P>Items to note:</P><P>list box for selection is Rpt_Yr and we limit this to only permit one choice, so we pass a parameter from this selection and calculate the second year for the variable vYear.&nbsp; vYear is 2012,2011.</P><P></P><P>If I use relativity, it would use all the rows and not give me the percentage of distinct projects impacted.&nbsp;&nbsp;&nbsp; </P><P></P><P></P></BODY></HTML> Thu, 24 May 2012 12:13:39 GMT https://community.qlik.com/t5/QlikView/Formulas-within-Charts/m-p/367668#M136720 2012-05-24T12:13:39Z