topic Expression Trouble in QlikView https://community.qlik.com/t5/QlikView/Expression-Trouble/m-p/179582#M46380 <HTML><HEAD></HEAD><BODY><P>Thanks for the help Moshea, appreciate it!</P></BODY></HTML> Thu, 24 Mar 2011 15:10:57 GMT 2011-03-24T15:10:57Z Expression Trouble https://community.qlik.com/t5/QlikView/Expression-Trouble/m-p/179579#M46377 <HTML><HEAD></HEAD><BODY><P>Currently I have a bar chart that gives me the total number of a holding bins.</P><P>However, sometimes theses hospitals have a number of different products</P><P>Currently I'm using the expression... "Count([Holding Bins])</P><P>I was wondering what kind of expression I could use to counnt the number of products in the holding bins as opposed to just the holding bins.</P><P>Hopefully that makes sense! Thanks for reading...</P></BODY></HTML> Thu, 24 Mar 2011 15:00:47 GMT https://community.qlik.com/t5/QlikView/Expression-Trouble/m-p/179579#M46377 2011-03-24T15:00:47Z Expression Trouble https://community.qlik.com/t5/QlikView/Expression-Trouble/m-p/179580#M46378 <HTML><HEAD></HEAD><BODY><P>What do you use as you dimension now?</P><P>I'm thinking you might want to make [Holding Bins] your dimensions and Count([Products]) as your expression. This assumes Products are tied to a bin. Is this what you mean?</P></BODY></HTML> Thu, 24 Mar 2011 15:05:26 GMT https://community.qlik.com/t5/QlikView/Expression-Trouble/m-p/179580#M46378 2011-03-24T15:05:26Z Expression Trouble https://community.qlik.com/t5/QlikView/Expression-Trouble/m-p/179581#M46379 <HTML><HEAD></HEAD><BODY><P>actually, i got it, no worries</P><P>used this expression... <B>aggr</B>(<B>sum</B>(<B>quantity</B>),<B>[HoldinglBin]</B>)</P></BODY></HTML> Thu, 24 Mar 2011 15:05:37 GMT https://community.qlik.com/t5/QlikView/Expression-Trouble/m-p/179581#M46379 2011-03-24T15:05:37Z Expression Trouble https://community.qlik.com/t5/QlikView/Expression-Trouble/m-p/179582#M46380 <HTML><HEAD></HEAD><BODY><P>Thanks for the help Moshea, appreciate it!</P></BODY></HTML> Thu, 24 Mar 2011 15:10:57 GMT https://community.qlik.com/t5/QlikView/Expression-Trouble/m-p/179582#M46380 2011-03-24T15:10:57Z