Skip to main content
You can succeed best and quickest by helping others to succeed. Join the conversation.
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

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

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!

0 Replies