https://community.qlik.com/t5/QlikView/aggr-not-working-in-expression/m-p/217740#M70925 <HTML><HEAD></HEAD><BODY><P>Guten Tag Rainer!</P><P>I inserted NODISTINCT in my aggr and now that particular chart works a treat:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=count(JobID) /aggr(NODISTINCT count(JobID),PriorityBandDescription)</PRE></BLOCKQUOTE><BR /><BR /> <P>Vielen Dank</P><P>michael</P></BODY></HTML> Fri, 16 Oct 2009 18:31:32 GMT 2009-10-16T18:31:32Z https://community.qlik.com/t5/QlikView/aggr-not-working-in-expression/m-p/217738#M70923 <HTML><HEAD></HEAD><BODY><P>Scenario: Customer satisfaction, based on job priority.</P><P>Jobs have different priorities, and customers rate their satisfaction afterwards. There are three satisfaction levels, 'Yes', 'No' and 'N/A'. There are four priorities.</P><P>I am attempting to rate percentage satisfaction against priority, rather than against all jobs (eg if there are a 17601 jobs, but only 12917 are Urgent, and of those 12917, 10487 customers were satisfied, then 81.19% is the satisfaction).</P><P>I cannot get a bar chart to do this, so I have been playing with a Straight Table chart to to see what figures come out.</P><P>If I add a calculated dimension with the formula</P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=aggr(count(jobID), PriorityBandDescription)</PRE>, the number I require appears against each row. If I add an expression with exactly the same formula, the number required only appears against one row for each PriorityBandDescription, with '-' against the others. This is my problem! Where am I going wrong?<BR /><BR /> <P>I would hope the expression I require is something like</P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=count(JobID) /aggr(count(total JobID), PriorityBandDescription)</PRE>, but that does not work. Help!<BR /><BR /> <P></P></BODY></HTML> Fri, 16 Oct 2009 17:25:43 GMT https://community.qlik.com/t5/QlikView/aggr-not-working-in-expression/m-p/217738#M70923 2009-10-16T17:25:43Z https://community.qlik.com/t5/QlikView/aggr-not-working-in-expression/m-p/217739#M70924 <HTML><HEAD></HEAD><BODY><P>Michael,</P><P>please provide a short QV example we can work with.</P><P>Thank you!</P><P>Rainer</P></BODY></HTML> Fri, 16 Oct 2009 18:11:57 GMT https://community.qlik.com/t5/QlikView/aggr-not-working-in-expression/m-p/217739#M70924 2009-10-16T18:11:57Z https://community.qlik.com/t5/QlikView/aggr-not-working-in-expression/m-p/217740#M70925 <HTML><HEAD></HEAD><BODY><P>Guten Tag Rainer!</P><P>I inserted NODISTINCT in my aggr and now that particular chart works a treat:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=count(JobID) /aggr(NODISTINCT count(JobID),PriorityBandDescription)</PRE></BLOCKQUOTE><BR /><BR /> <P>Vielen Dank</P><P>michael</P></BODY></HTML> Fri, 16 Oct 2009 18:31:32 GMT https://community.qlik.com/t5/QlikView/aggr-not-working-in-expression/m-p/217740#M70925 2009-10-16T18:31:32Z