topic help with total in QlikView https://community.qlik.com/t5/QlikView/help-with-total/m-p/908598#M991344 <HTML><HEAD></HEAD><BODY><P>Hi guys need help with total in the attached application there are 2 columns Frt Test and Pr Frt Test which we need to focus I am getting two different values in these columns one is 126 and other being 172. 126 I am getting by using sum of rows in the expression tab.What I want is to store this 126 in an expression so that I can use it further in calculations.</P><P></P><P>I am looking for Primary frt*Qty grouped by Sub Division,for med device it should give a sum of 126 not 172 as it is giving the total,anyhow.</P><P>Also please see the order type is SO.</P><P></P><P>I took it in excel and found out there is a lil difference between these two columns in the last of the rows.</P><P></P><P>Appreciate your help.</P></BODY></HTML> Tue, 21 Jul 2015 16:50:28 GMT Anonymous 2015-07-21T16:50:28Z help with total https://community.qlik.com/t5/QlikView/help-with-total/m-p/908598#M991344 <HTML><HEAD></HEAD><BODY><P>Hi guys need help with total in the attached application there are 2 columns Frt Test and Pr Frt Test which we need to focus I am getting two different values in these columns one is 126 and other being 172. 126 I am getting by using sum of rows in the expression tab.What I want is to store this 126 in an expression so that I can use it further in calculations.</P><P></P><P>I am looking for Primary frt*Qty grouped by Sub Division,for med device it should give a sum of 126 not 172 as it is giving the total,anyhow.</P><P>Also please see the order type is SO.</P><P></P><P>I took it in excel and found out there is a lil difference between these two columns in the last of the rows.</P><P></P><P>Appreciate your help.</P></BODY></HTML> Tue, 21 Jul 2015 16:50:28 GMT https://community.qlik.com/t5/QlikView/help-with-total/m-p/908598#M991344 Anonymous 2015-07-21T16:50:28Z