topic Re: need help in QlikView https://community.qlik.com/t5/QlikView/need-help/m-p/680343#M1086727 <HTML><HEAD></HEAD><BODY><P>Where is the sales data?</P></BODY></HTML> Sat, 14 Jun 2014 10:01:22 GMT MK_QSL 2014-06-14T10:01:22Z need help https://community.qlik.com/t5/QlikView/need-help/m-p/680342#M1086726 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>PFA,</P></BODY></HTML> Sat, 14 Jun 2014 01:37:03 GMT https://community.qlik.com/t5/QlikView/need-help/m-p/680342#M1086726 paulwalker 2014-06-14T01:37:03Z Re: need help https://community.qlik.com/t5/QlikView/need-help/m-p/680343#M1086727 <HTML><HEAD></HEAD><BODY><P>Where is the sales data?</P></BODY></HTML> Sat, 14 Jun 2014 10:01:22 GMT https://community.qlik.com/t5/QlikView/need-help/m-p/680343#M1086727 MK_QSL 2014-06-14T10:01:22Z Re: need help https://community.qlik.com/t5/QlikView/need-help/m-p/680344#M1086728 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>Sales data is nothing but a SalesQty only</P></BODY></HTML> Sat, 14 Jun 2014 10:03:51 GMT https://community.qlik.com/t5/QlikView/need-help/m-p/680344#M1086728 paulwalker 2014-06-14T10:03:51Z Re: need help https://community.qlik.com/t5/QlikView/need-help/m-p/680345#M1086729 <HTML><HEAD></HEAD><BODY><P>where is sales data?</P></BODY></HTML> Sat, 14 Jun 2014 10:15:45 GMT https://community.qlik.com/t5/QlikView/need-help/m-p/680345#M1086729 MK_QSL 2014-06-14T10:15:45Z Re: need help https://community.qlik.com/t5/QlikView/need-help/m-p/680346#M1086730 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P><STRONG>Outside sales </STRONG>that is field name only, i don't have any sales data...</P><P>only calculate based on <STRONG> SalesQty</STRONG></P></BODY></HTML> Sat, 14 Jun 2014 11:42:43 GMT https://community.qlik.com/t5/QlikView/need-help/m-p/680346#M1086730 paulwalker 2014-06-14T11:42:43Z Re: Re: need help https://community.qlik.com/t5/QlikView/need-help/m-p/680347#M1086731 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Paul - Have you tried to create a drill down group on <SPAN style="color: #222222;">country/state/city/zip</SPAN> and use this group as your Dimesion. Then your expression will be Sum(SalesQty).</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">I hope this helps!</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Cheers,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">DV</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">www.QlikShare.com</SPAN></P></BODY></HTML> Sat, 14 Jun 2014 11:43:32 GMT https://community.qlik.com/t5/QlikView/need-help/m-p/680347#M1086731 IAMDV 2014-06-14T11:43:32Z Re: need help https://community.qlik.com/t5/QlikView/need-help/m-p/680348#M1086732 <HTML><HEAD></HEAD><BODY><P>Hi Deepak,</P><P></P><P>That is ok, but i have one more dimension <STRONG>Outside sale Person</STRONG></P><P><SPAN style="color: #222222; font-family: calibri, verdana, arial, sans-serif;"><STRONG>country/state/city/zip</STRONG></SPAN> this is Drill down</P><P><STRONG>Sum(SalesQty)</STRONG> expression</P><P></P><P><SPAN style="color: #222222; font-family: arial, sans-serif;"><STRONG>Outside Sales rep</STRONG> performance based on volume <STRONG>sales</STRONG> &amp; growth in sales&nbsp; can be drilled on <STRONG>country/state/city/zip</STRONG></SPAN></P><P><SPAN style="color: #222222; font-family: arial, sans-serif;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="color: #222222; font-family: arial, sans-serif;">Hope you understand..<STRONG><BR /></STRONG></SPAN></P></BODY></HTML> Sun, 15 Jun 2014 06:29:49 GMT https://community.qlik.com/t5/QlikView/need-help/m-p/680348#M1086732 paulwalker 2014-06-15T06:29:49Z