Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

chinnuchinni
Contributor III

How to find current & next month sales based on 4-4-5 calender dates.

Hi All,

 

I created the 4-4-5 calender based on my available dates. now I want to calculate  the current month sales and next month sales based on this 4-4-5 calender dates.

 

let say for example for current month start from 27/01/2019 to 23/02/2019.

and next month start from 24/02/2019 to 30/03/2019.

 

can any one please suggest. it is very very urgent requirement.

Regards

PC

 

1 Reply
prieper
Honored Contributor II

Re: How to find current & next month sales based on 4-4-5 calender dates.

Suggest to check Henrik's blogpost on this subject:

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-4-4-5-Calendar/ba-p/1464069

 

Peter