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!