topic calculate total value only associate with two dimensions in QlikView https://community.qlik.com/t5/QlikView/calculate-total-value-only-associate-with-two-dimensions/m-p/615176#M226955 <HTML><HEAD></HEAD><BODY><P><BR />Hi there,</P><P></P><P>I am working on a dashbaord utilizing retail data. The data field includes item code, store code, invoice date, department and item sales quantity. I am going to calculate the total sales for all the itmes sold on specific day in the specific store.</P><P></P><P>I have tried expression=sum(item_qty) but it does not work since the value will change when specific department is selected. Is there a way to do the calculation of total value which will not change regardless item code and department are selected.</P><P></P><P>Thank you!</P><P></P><P>Gloria</P></BODY></HTML> Thu, 20 Feb 2014 22:15:27 GMT 2014-02-20T22:15:27Z calculate total value only associate with two dimensions https://community.qlik.com/t5/QlikView/calculate-total-value-only-associate-with-two-dimensions/m-p/615176#M226955 <HTML><HEAD></HEAD><BODY><P><BR />Hi there,</P><P></P><P>I am working on a dashbaord utilizing retail data. The data field includes item code, store code, invoice date, department and item sales quantity. I am going to calculate the total sales for all the itmes sold on specific day in the specific store.</P><P></P><P>I have tried expression=sum(item_qty) but it does not work since the value will change when specific department is selected. Is there a way to do the calculation of total value which will not change regardless item code and department are selected.</P><P></P><P>Thank you!</P><P></P><P>Gloria</P></BODY></HTML> Thu, 20 Feb 2014 22:15:27 GMT https://community.qlik.com/t5/QlikView/calculate-total-value-only-associate-with-two-dimensions/m-p/615176#M226955 2014-02-20T22:15:27Z Re: calculate total value only associate with two dimensions https://community.qlik.com/t5/QlikView/calculate-total-value-only-associate-with-two-dimensions/m-p/615177#M226956 <HTML><HEAD></HEAD><BODY><P>sum( {&lt;item_code=, department= &gt;} item_qty)</P><P>will exclude selections on item_code or department from the quantity, selections on other fields will still affect the figure.</P></BODY></HTML> Thu, 20 Feb 2014 22:23:22 GMT https://community.qlik.com/t5/QlikView/calculate-total-value-only-associate-with-two-dimensions/m-p/615177#M226956 Colin-Albert 2014-02-20T22:23:22Z Re: calculate total value only associate with two dimensions https://community.qlik.com/t5/QlikView/calculate-total-value-only-associate-with-two-dimensions/m-p/615178#M226957 <HTML><HEAD></HEAD><BODY><P>There is more info on set analysis and a wizard to help create the expressions here.</P><P><A _jive_internal="true" href="https://community.qlik.com/message/170190#170190">http://community.qlik.com/message/170190#170190</A></P></BODY></HTML> Thu, 20 Feb 2014 22:27:13 GMT https://community.qlik.com/t5/QlikView/calculate-total-value-only-associate-with-two-dimensions/m-p/615178#M226957 Colin-Albert 2014-02-20T22:27:13Z Re: calculate total value only associate with two dimensions https://community.qlik.com/t5/QlikView/calculate-total-value-only-associate-with-two-dimensions/m-p/615179#M226958 <HTML><HEAD></HEAD><BODY><P>Thank you so much for your help!! It works!</P></BODY></HTML> Thu, 20 Feb 2014 22:51:41 GMT https://community.qlik.com/t5/QlikView/calculate-total-value-only-associate-with-two-dimensions/m-p/615179#M226958 2014-02-20T22:51:41Z