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: 
pkseenu
Contributor
Contributor

Average and projection in qlik sense

Hi, 

 

I want to calculate the projection of current average value for month. Till Oct 11, 2020 my average is 1.89 using the below expression:

avg({<
$(v_Incident_Exclusion),
[Resolved Date.autoCalendar.YearMonth]={"$(v_MTD3)"},
SNOW_incident_incident_state={"Resolved","Closed"},
[SNOW_incident_u_substatus] -={"Cancelled"}
>}[SNOW_incident_u_resolved]-[SNOW_incident_sys_created_on])

 

When I want to project this average for rest of the month I am not getting the desired answer. 

 

What I did 

avg({<
$(v_Incident_Exclusion),
[Resolved Date.autoCalendar.YearMonth]={"$(v_MTD3)"},
SNOW_incident_incident_state={"Resolved","Closed"},
[SNOW_incident_u_substatus] -={"Cancelled"}
>}[SNOW_incident_u_resolved]-[SNOW_incident_sys_created_on])/11(number of days so far)*31(total number of days for the month)

 

I am not getting the right result. thanks in advance

2 Replies
Kushal_Chawda

@pkseenu can you share sample with expected output?

pkseenu
Contributor
Contributor
Author

HI Kush,

Sorry I can't share the sample qvf. it is not allowed in my company 😞