Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jhstrange
Contributor II
Contributor II

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

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.

0 Replies