0 Replies Latest reply: Nov 1, 2016 1:13 PM by Troy Strachan RSS

    Old rates and new rates how do you deal with them?

    Troy Strachan

      Hey everyone,

      I am looking a fairly common problem, but I can't figure out how to get the accurate numbers.

      What I'm looking at is we have 2 rates, the rate changes on October 1. When trying to do an analysis, we are getting the original rate.

      Rate prior to October 1 is $5.00

      Rate starting October 1 is $10.00

      If I look at September 15 to October 15, the rate Qlik Sense chooses for the calculation is $5.00. Can it update the rate in the middle of the analysis?

      How do you deal with this? Also, what happens when we add a third rate January 1?

      Any help/guidance is much appreciated!