topic Re: Re: GROUP BY in QlikView https://community.qlik.com/t5/QlikView/GROUP-BY/m-p/483340#M687214 <HTML><HEAD></HEAD><BODY><P><STRONG>Alon</STRONG></P><P></P><P>Manish got there first, my qvw is very similar his.</P><P></P><P>It is shame that their are no common dimensions for the 2 tables to give some slicing &amp; dicing, but unfortunately that is oft the case with real data from the real world.</P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Sun, 24 Nov 2013 19:57:47 GMT Anonymous 2013-11-24T19:57:47Z GROUP BY https://community.qlik.com/t5/QlikView/GROUP-BY/m-p/483337#M687211 <HTML><HEAD></HEAD><BODY><P>How can i make group by on the sales?</P><P><SPAN class="hps">I want</SPAN> <SPAN class="hps">to compare</SPAN> <SPAN class="hps">total</SPAN> <SPAN class="hps">sales</SPAN> <SPAN class="hps">by month</SPAN>-</P><P> to compare the total sales&nbsp; of january to the total forecast of january e<SPAN class="hps">tc.</SPAN></P></BODY></HTML> Sun, 24 Nov 2013 18:20:12 GMT https://community.qlik.com/t5/QlikView/GROUP-BY/m-p/483337#M687211 2013-11-24T18:20:12Z Re: GROUP BY https://community.qlik.com/t5/QlikView/GROUP-BY/m-p/483338#M687212 <HTML><HEAD></HEAD><BODY><P>Don't know what you really want. Please check attached file...</P></BODY></HTML> Sun, 24 Nov 2013 19:25:22 GMT https://community.qlik.com/t5/QlikView/GROUP-BY/m-p/483338#M687212 MK_QSL 2013-11-24T19:25:22Z Re: GROUP BY https://community.qlik.com/t5/QlikView/GROUP-BY/m-p/483339#M687213 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">I want to</SPAN> <SPAN class="hps">write a</SPAN> <SPAN class="hps">script (in the edit scrupt)</SPAN> <SPAN class="hps">that will bring</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">total</SPAN> <SPAN class="hps">actual sales</SPAN> <SPAN class="hps">of each month</SPAN> <SPAN class="hps">versus</SPAN> <SPAN class="hps">a forecast of</SPAN> <SPAN class="hps">sales</SPAN> <SPAN class="hps">each month</SPAN>.</P><P><SPAN class="hps">The Field</SPAN> <SPAN class="hps">sales in the</SPAN> <SPAN class="hps">forecast</SPAN> <SPAN class="hps">table </SPAN>is<SPAN class="atn hps">"</SPAN>Forecast_Amount".</P><P><SPAN class="hps">The Field</SPAN> <SPAN class="hps">sales in the</SPAN> <SPAN class="hps">table</SPAN> <SPAN class="hps">Sales_Actual</SPAN> <SPAN class="hps">is</SPAN> <SPAN class="atn hps">"</SPAN>Amount".</P></BODY></HTML> Sun, 24 Nov 2013 19:51:17 GMT https://community.qlik.com/t5/QlikView/GROUP-BY/m-p/483339#M687213 2013-11-24T19:51:17Z Re: Re: GROUP BY https://community.qlik.com/t5/QlikView/GROUP-BY/m-p/483340#M687214 <HTML><HEAD></HEAD><BODY><P><STRONG>Alon</STRONG></P><P></P><P>Manish got there first, my qvw is very similar his.</P><P></P><P>It is shame that their are no common dimensions for the 2 tables to give some slicing &amp; dicing, but unfortunately that is oft the case with real data from the real world.</P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Sun, 24 Nov 2013 19:57:47 GMT https://community.qlik.com/t5/QlikView/GROUP-BY/m-p/483340#M687214 Anonymous 2013-11-24T19:57:47Z