0 Replies Latest reply: Oct 22, 2018 8:09 PM by Joel Strange RSS

    Monthly based value to be applied for a single day or week in QlikSense

    Joel Strange

      I have 2 fields :The 1st one has data such as "10/01/2018 to 10/31/2018" and "11/01/2018 to 11/30/2018" and the 2nd one is a measure (Monthly Forecasted revenue) which has values like 25000$ and 40000$.

       

      How to apply the Forecasted Revenue value on a daily or weekly basis?Ex If a person selects 11/15/2018 as the date filter,he or she should be able to see the value as 40000/30(since 30 days in November) and if the person selects a week in Nov,the value should be 40000*7/30

       

      Right now the entire month value is being shown even if I select a particular date or a week.

       

      Thanks in advance.