Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.