Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shearwatertroy
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