topic Re: Help with a chart behaving oddly! in QlikView https://community.qlik.com/t5/QlikView/Help-with-a-chart-behaving-oddly/m-p/502699#M187845 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use TOTAL in the denominator expression like this</P><P></P><P>Count({&lt;Set analysis&gt;} TOTAL DISTINCT TID)</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 11 Nov 2013 03:43:57 GMT jagan 2013-11-11T03:43:57Z Help with a chart behaving oddly! https://community.qlik.com/t5/QlikView/Help-with-a-chart-behaving-oddly/m-p/502698#M187844 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'trebuchet ms', geneva;">Below you can see 2 text boxes A and B that are the results of the set analysis formula that you can see - "B" is always the same irrespective of the MonthYear chosen on the right and "A" shows me the results I expect as I chose a MonthYear or (as is the case here) all the results. "C" is simply A/B. The results in the text boxes are always correct but plotting C against MonthYear always gives me 1. This is driving me insane. Can someone throw some light please?</SPAN></P><P></P><P><SPAN style="font-family: 'trebuchet ms', geneva;">Thanx</SPAN></P><P><SPAN style="font-family: 'trebuchet ms', geneva;">Alexis</SPAN></P><P><SPAN style="font-family: 'trebuchet ms', geneva;"><IMG alt="chart1.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/48815_chart1.jpg" style="width: 620px; height: 673px;" /><BR /></SPAN></P></BODY></HTML> Mon, 11 Nov 2013 00:50:38 GMT https://community.qlik.com/t5/QlikView/Help-with-a-chart-behaving-oddly/m-p/502698#M187844 alexis 2013-11-11T00:50:38Z Re: Help with a chart behaving oddly! https://community.qlik.com/t5/QlikView/Help-with-a-chart-behaving-oddly/m-p/502699#M187845 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use TOTAL in the denominator expression like this</P><P></P><P>Count({&lt;Set analysis&gt;} TOTAL DISTINCT TID)</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 11 Nov 2013 03:43:57 GMT https://community.qlik.com/t5/QlikView/Help-with-a-chart-behaving-oddly/m-p/502699#M187845 jagan 2013-11-11T03:43:57Z Re: Help with a chart behaving oddly! https://community.qlik.com/t5/QlikView/Help-with-a-chart-behaving-oddly/m-p/502700#M187846 <HTML><HEAD></HEAD><BODY><P>Thanks Jagan - I knew the answer would be simple!</P></BODY></HTML> Mon, 11 Nov 2013 08:29:06 GMT https://community.qlik.com/t5/QlikView/Help-with-a-chart-behaving-oddly/m-p/502700#M187846 alexis 2013-11-11T08:29:06Z