Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
cecing
Contributor
Contributor

Create a MoM % sales change KPI

Hi! I am trying to have a % change month over month kpi indicator for sales, based on the selection of a date.

I am thinking on using set analysis for this, to grab the max of current month minus max of current month -1.

However I would lik to know if any of you have a simple way to calculate MoM %

Any help would be appreciated!

Labels (1)
1 Reply
LeeSmithBtn
Partner - Creator
Partner - Creator

Not sure if this helps... and it may be slightly overkill for what you are trying to achieve...

but i find this link and this master calendar creation process that Richard pearce created some time ago for qlikview but equally works well for Qlik Sense. it cantake some getting used to, / setting up against your qlik model. but once in, its extremely useful and fast to compare periods

https://qlikcentral.com/2014/05/16/calendar-with-flags-making-set-analysis-so-very-simple/

attached is the qlikview (with explanations and pages laid out to explain what its doing). version (can be adapted screens to run on qlik sense), but have also attached the .qvf that i have converted to use this but just needs importing, reloading and playing with... can use this to do as little or as much as you want, including from and to dates 🙂

it makes comparing mtd, prev months, prev month prev year etc very easy in the long run with a simple flag and needs to be joined on your date field.