1 Reply Latest reply: Jul 29, 2015 6:06 PM by Robert Mika RSS

    Comparing two tables to calculate trends

    Robert Fishel

      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