topic Re: Dimension Calculation in QlikView https://community.qlik.com/t5/QlikView/Dimension-Calculation/m-p/755625#M666815 <HTML><HEAD></HEAD><BODY><P>Reload the apps and give as an attachment!</P></BODY></HTML> Wed, 17 Dec 2014 16:16:05 GMT MK_QSL 2014-12-17T16:16:05Z Dimension Calculation https://community.qlik.com/t5/QlikView/Dimension-Calculation/m-p/755624#M666814 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">I attached a QVW that contains my test data.&nbsp; </SPAN></P><P></P><P><SPAN style="font-size: 12pt;">I want to crate a straight table that tells me how many employees had X number of sales over a date range (weeks).&nbsp; Example of table below...</SPAN></P><P></P><P>Sale Count&nbsp;&nbsp;&nbsp;&nbsp; Employee Count&nbsp;&nbsp;&nbsp;&nbsp; AVG Sale Total</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $35</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $28</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $34&nbsp;&nbsp;&nbsp; </P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $25</P><P>5+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; #16</P><P></P><P></P><P>I have a unique key for each transaction/Sale.&nbsp; I believe I need to create a calculated dimension using that unique sale key.</P><P></P><P>Any help would greatly be appreciated.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 17 Dec 2014 16:14:17 GMT https://community.qlik.com/t5/QlikView/Dimension-Calculation/m-p/755624#M666814 2014-12-17T16:14:17Z Re: Dimension Calculation https://community.qlik.com/t5/QlikView/Dimension-Calculation/m-p/755625#M666815 <HTML><HEAD></HEAD><BODY><P>Reload the apps and give as an attachment!</P></BODY></HTML> Wed, 17 Dec 2014 16:16:05 GMT https://community.qlik.com/t5/QlikView/Dimension-Calculation/m-p/755625#M666815 MK_QSL 2014-12-17T16:16:05Z Re: Dimension Calculation https://community.qlik.com/t5/QlikView/Dimension-Calculation/m-p/755626#M666816 <HTML><HEAD></HEAD><BODY><P>your qvw has no data loaded into it</P></BODY></HTML> Wed, 17 Dec 2014 16:18:56 GMT https://community.qlik.com/t5/QlikView/Dimension-Calculation/m-p/755626#M666816 2014-12-17T16:18:56Z Re: Dimension Calculation https://community.qlik.com/t5/QlikView/Dimension-Calculation/m-p/755627#M666817 <HTML><HEAD></HEAD><BODY><P>qvw seems to have no data.</P></BODY></HTML> Wed, 17 Dec 2014 16:28:12 GMT https://community.qlik.com/t5/QlikView/Dimension-Calculation/m-p/755627#M666817 saurabh5 2014-12-17T16:28:12Z Re: Dimension Calculation https://community.qlik.com/t5/QlikView/Dimension-Calculation/m-p/755628#M666818 <HTML><HEAD></HEAD><BODY><P>I reattached the dashboard.&nbsp; Sorry about that.</P></BODY></HTML> Wed, 17 Dec 2014 16:48:00 GMT https://community.qlik.com/t5/QlikView/Dimension-Calculation/m-p/755628#M666818 2014-12-17T16:48:00Z Re: Dimension Calculation https://community.qlik.com/t5/QlikView/Dimension-Calculation/m-p/755629#M666819 <HTML><HEAD></HEAD><BODY><P>I reloaded the data.&nbsp; Sorry about that</P></BODY></HTML> Wed, 17 Dec 2014 17:12:00 GMT https://community.qlik.com/t5/QlikView/Dimension-Calculation/m-p/755629#M666819 2014-12-17T17:12:00Z Re: Dimension Calculation https://community.qlik.com/t5/QlikView/Dimension-Calculation/m-p/755630#M666820 <HTML><HEAD></HEAD><BODY><P>I reloaded the data.&nbsp; Sorry about that.</P></BODY></HTML> Wed, 17 Dec 2014 17:12:20 GMT https://community.qlik.com/t5/QlikView/Dimension-Calculation/m-p/755630#M666820 2014-12-17T17:12:20Z