topic Re: how to create a table from caluculated values in QlikView https://community.qlik.com/t5/QlikView/how-to-create-a-table-from-caluculated-values/m-p/661894#M241256 <HTML><HEAD></HEAD><BODY><P><BR />I have two tables like:</P><P></P><P>Table1:</P><P>policyNumbe rpremium1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 70</P><P></P><P>can create a list box</P><P>Policy&nbsp; Premium2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</P><P>poicy is the primary key. I want to create list box with diffirence of premium1 and premium2.</P><P>Thanks</P></BODY></HTML> Wed, 27 Aug 2014 15:01:43 GMT 2014-08-27T15:01:43Z how to create a table from caluculated values https://community.qlik.com/t5/QlikView/how-to-create-a-table-from-caluculated-values/m-p/661892#M241254 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have two dat sets</P><P></P><P>Policy Premium1</P><P></P><P>Policy Premium2</P><P></P><P>I need to caluculate the difference of Premium1 and Premium2 and store in a diffirent table.</P></BODY></HTML> Wed, 27 Aug 2014 14:31:41 GMT https://community.qlik.com/t5/QlikView/how-to-create-a-table-from-caluculated-values/m-p/661892#M241254 2014-08-27T14:31:41Z Re: how to create a table from caluculated values https://community.qlik.com/t5/QlikView/how-to-create-a-table-from-caluculated-values/m-p/661893#M241255 <HTML><HEAD></HEAD><BODY><P>You need to have link between two tables... Kindly provide some sample data...</P></BODY></HTML> Wed, 27 Aug 2014 14:32:16 GMT https://community.qlik.com/t5/QlikView/how-to-create-a-table-from-caluculated-values/m-p/661893#M241255 MK_QSL 2014-08-27T14:32:16Z Re: how to create a table from caluculated values https://community.qlik.com/t5/QlikView/how-to-create-a-table-from-caluculated-values/m-p/661894#M241256 <HTML><HEAD></HEAD><BODY><P><BR />I have two tables like:</P><P></P><P>Table1:</P><P>policyNumbe rpremium1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 70</P><P></P><P>can create a list box</P><P>Policy&nbsp; Premium2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</P><P>poicy is the primary key. I want to create list box with diffirence of premium1 and premium2.</P><P>Thanks</P></BODY></HTML> Wed, 27 Aug 2014 15:01:43 GMT https://community.qlik.com/t5/QlikView/how-to-create-a-table-from-caluculated-values/m-p/661894#M241256 2014-08-27T15:01:43Z Re: how to create a table from caluculated values https://community.qlik.com/t5/QlikView/how-to-create-a-table-from-caluculated-values/m-p/661895#M241257 <HTML><HEAD></HEAD><BODY><P>Kindly provide proper data... Policy is missing from the data you have given..</P></BODY></HTML> Wed, 27 Aug 2014 15:06:51 GMT https://community.qlik.com/t5/QlikView/how-to-create-a-table-from-caluculated-values/m-p/661895#M241257 MK_QSL 2014-08-27T15:06:51Z