topic Re: How to calculate expression?? in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-expression/m-p/501904#M1147039 <HTML><HEAD></HEAD><BODY><P>Please read these two documents:</P><UL><LI><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-2380" style="color: #007fc0; text-decoration: initial;">QlikCommunity Tip: How to get answers to your post?</A></LI><LI><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-1290" style="color: #007fc0; text-decoration: initial;">Preparing examples for Upload - Reduction and Data Scrambling</A>.</LI></UL></BODY></HTML> Fri, 19 Jul 2013 15:21:50 GMT Gysbert_Wassenaar 2013-07-19T15:21:50Z How to calculate expression?? https://community.qlik.com/t5/QlikView/How-to-calculate-expression/m-p/501901#M1147036 <HTML><HEAD></HEAD><BODY><P>how to do sum of a field depending on period_key and product_key group by....in expression of qlikview??</P></BODY></HTML> Fri, 19 Jul 2013 13:58:22 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-expression/m-p/501901#M1147036 suvechha_b 2013-07-19T13:58:22Z Re: How to calculate expression?? https://community.qlik.com/t5/QlikView/How-to-calculate-expression/m-p/501902#M1147037 <HTML><HEAD></HEAD><BODY><P>In a chart you use period_key and product_key as dimensions and sum(field) as expression.</P><P></P><P>In the script you can do something like:</P><P></P><P>load</P><P>&nbsp;&nbsp;&nbsp; period_key,</P><P>&nbsp;&nbsp;&nbsp; product_key,</P><P>&nbsp;&nbsp;&nbsp; sum(field) as PeriodProductSum</P><P>from ...somewhere...</P><P>group by period_key, product_key;</P></BODY></HTML> Fri, 19 Jul 2013 14:11:24 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-expression/m-p/501902#M1147037 Gysbert_Wassenaar 2013-07-19T14:11:24Z Re: How to calculate expression?? https://community.qlik.com/t5/QlikView/How-to-calculate-expression/m-p/501903#M1147038 <HTML><HEAD></HEAD><BODY><P>no I dont want period_key and product_key as dimension,</P><P></P><P>I only want the sum(actual_receipts_qty) against fiscal_year and fiscal_month and product_code.</P><P></P><P></P><P>I have tried your script but it is giving error at load..</P><P></P><P></P><P>I am new, Plz tell me step by step</P></BODY></HTML> Fri, 19 Jul 2013 15:11:31 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-expression/m-p/501903#M1147038 suvechha_b 2013-07-19T15:11:31Z Re: How to calculate expression?? https://community.qlik.com/t5/QlikView/How-to-calculate-expression/m-p/501904#M1147039 <HTML><HEAD></HEAD><BODY><P>Please read these two documents:</P><UL><LI><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-2380" style="color: #007fc0; text-decoration: initial;">QlikCommunity Tip: How to get answers to your post?</A></LI><LI><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-1290" style="color: #007fc0; text-decoration: initial;">Preparing examples for Upload - Reduction and Data Scrambling</A>.</LI></UL></BODY></HTML> Fri, 19 Jul 2013 15:21:50 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-expression/m-p/501904#M1147039 Gysbert_Wassenaar 2013-07-19T15:21:50Z