topic How to store the calculated data value in QlikView https://community.qlik.com/t5/QlikView/How-to-store-the-calculated-data-value/m-p/217075#M70324 <HTML><HEAD></HEAD><BODY><P>How to store the calculated data value of two different fields say invoice(weight) and contract(weight) which are in different tables and i want to subtarct the values of two fields and want to show in a Pivot Table and want to make a list box with heading Status underneath Complete/Pending will show.When i will clikc on Complete on list box it the pivot table will show all complete records.</P></BODY></HTML> Wed, 08 Dec 2010 11:02:47 GMT 2010-12-08T11:02:47Z How to store the calculated data value https://community.qlik.com/t5/QlikView/How-to-store-the-calculated-data-value/m-p/217075#M70324 <HTML><HEAD></HEAD><BODY><P>How to store the calculated data value of two different fields say invoice(weight) and contract(weight) which are in different tables and i want to subtarct the values of two fields and want to show in a Pivot Table and want to make a list box with heading Status underneath Complete/Pending will show.When i will clikc on Complete on list box it the pivot table will show all complete records.</P></BODY></HTML> Wed, 08 Dec 2010 11:02:47 GMT https://community.qlik.com/t5/QlikView/How-to-store-the-calculated-data-value/m-p/217075#M70324 2010-12-08T11:02:47Z How to store the calculated data value https://community.qlik.com/t5/QlikView/How-to-store-the-calculated-data-value/m-p/217076#M70325 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am attaching a sample application, just check it and let me know, is that what you are looking for.</P><P></P><P>Regards</P><P>Ranjit</P></BODY></HTML> Wed, 08 Dec 2010 11:35:12 GMT https://community.qlik.com/t5/QlikView/How-to-store-the-calculated-data-value/m-p/217076#M70325 renjithpl 2010-12-08T11:35:12Z How to store the calculated data value https://community.qlik.com/t5/QlikView/How-to-store-the-calculated-data-value/m-p/217077#M70326 <HTML><HEAD></HEAD><BODY><P>hii</P><P>Actually u are taking status field and make in complete or pending which is much more like hard code i just want to make that contract (weight)- invoice(weight)&gt;0 then pending else complete</P></BODY></HTML> Wed, 08 Dec 2010 12:11:54 GMT https://community.qlik.com/t5/QlikView/How-to-store-the-calculated-data-value/m-p/217077#M70326 2010-12-08T12:11:54Z