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: 
cyrilleleja
Contributor
Contributor

How to compare sales évolution month by month

 

 

 

Dear community, 

I would like to compare automatically sales of December 2018 with sales of November 2018 and put in mesure the evolution rate (+ or – and %).

The difficulty is that I have sales for December (1 to 5 december) and I would like to compate with sales from 1 to 5 november and not the full month,

Tomorrow when I will check my KPI it should be evolution between 1 to 6 november ans 1 to 6 december…

This is my mesure to have sale for December 2018 :

count(aggr(if(year(date_signup) = year(today()-1) and month(date_signup) = month(today()-1) and FID_ANA_NUM = 1 ,1),[FID_shop_id-Offre - Identifiant unique]))

and I would like to have :

count(aggr(if(year(date_signup) = year(today()-1) and month(date_signup) = month(today()-1) and FID_ANA_NUM = 1 ,1),[FID_shop_id-Offre - Identifiant unique])) / sales of month-1 from 1 to 5 etc …

 

 regards, 

 

Cyrille

 

 

 

 

 

1 Reply
cyrilleleja
Contributor
Contributor
Author

No ideas ? Smiley Sad