To Derive forecast in different quarters in Qlikview
I have a problem in hand to derive the Revenue Forecast for various Quarters.
I have Start date and End date and Rate Value. All i need to derive is to find out the Start Date is in Which Quarter and if the end date is carried forward to next Quarter then i have to display the value in the both the quarters
1-Nov-17 to 31-Jan-18
Then i have to Calculate the revenue from 1-Nov to 31-Dec-17 as Q3 and 1-Jan-18 to 31-Jan-18 as Q4.
i am trying to Quartername & Networkdays for the derivation.