0 Replies Latest reply: Nov 25, 2017 6:28 AM by Somasundaram R RSS

    To Derive forecast in different quarters in Qlikview

    Somasundaram R

      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.