Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
rsomalti
New Contributor

To Derive forecast in different quarters in Qlikview

Hi Folks

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

Example -

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.

Community Browser