Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?