Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
shearwatertroy
New 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!

Tags (1)
Community Browser