Discussion board where members can get started with QlikView.
I am not sure if this is a Set Analysis Question or not.
Basically I need to subtract the current time period measure from the measure for every time period across the dimension.
I do not have the "Variance from Current Quarter" in my dataset. I need to calculate that.
I took my crosstab table and made it longer by adding the Measurement Column, to take place of the data I recieved, which came to me like this:
If you can point me in the direction for the best way to do this, I would appreciate the help.
Go to Solution.
I did it through some scripting. I don't think it was the perfect answer, but it works.
View solution in original post