Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.


Comparing two tables to calculate trends

Hello my QlikView friends.  I have an issue and I am trying to figure out the most efficient way to accomplish it.  I have two different data sets (tables) with the same field names.  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.  I am trying to figure out how I should load the data.  Also, could this be accomplished in one data set, meaning if I combined the two tables could I still calculate the trending?  Thanks you

1 Reply

Re: Comparing two tables to calculate trends

Is that one field per table or more?

Could you load your data?