topic Comparing two tables to calculate trends in QlikView https://community.qlik.com/t5/QlikView/Comparing-two-tables-to-calculate-trends/m-p/920508#M653128 <HTML><HEAD></HEAD><BODY><P>Hello my QlikView friends.&nbsp; I have an issue and I am trying to figure out the most efficient way to accomplish it.&nbsp; I have two different data sets (tables) with the same field names.&nbsp; I want to compare the two and calculate the difference between two particular columns of data as well as the percent change between each field in those two columns.&nbsp; I am trying to figure out how I should load the data.&nbsp; Also, could this be accomplished in one data set, meaning if I combined the two tables could I still calculate the trending?&nbsp; Thanks you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 29 Jul 2015 18:13:38 GMT Anonymous 2015-07-29T18:13:38Z Comparing two tables to calculate trends https://community.qlik.com/t5/QlikView/Comparing-two-tables-to-calculate-trends/m-p/920508#M653128 <HTML><HEAD></HEAD><BODY><P>Hello my QlikView friends.&nbsp; I have an issue and I am trying to figure out the most efficient way to accomplish it.&nbsp; I have two different data sets (tables) with the same field names.&nbsp; I want to compare the two and calculate the difference between two particular columns of data as well as the percent change between each field in those two columns.&nbsp; I am trying to figure out how I should load the data.&nbsp; Also, could this be accomplished in one data set, meaning if I combined the two tables could I still calculate the trending?&nbsp; Thanks you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 29 Jul 2015 18:13:38 GMT https://community.qlik.com/t5/QlikView/Comparing-two-tables-to-calculate-trends/m-p/920508#M653128 Anonymous 2015-07-29T18:13:38Z Re: Comparing two tables to calculate trends https://community.qlik.com/t5/QlikView/Comparing-two-tables-to-calculate-trends/m-p/920509#M653129 <HTML><HEAD></HEAD><BODY><P>Is that one field per table or more?</P><P>Could you load your data?</P></BODY></HTML> Wed, 29 Jul 2015 22:06:23 GMT https://community.qlik.com/t5/QlikView/Comparing-two-tables-to-calculate-trends/m-p/920509#M653129 robert_mika 2015-07-29T22:06:23Z