Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
robert_mika
Master III
Master III

Is that one field per table or more?

Could you load your data?