Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is that one field per table or more?
Could you load your data?