Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
3 Keynotes, 100+ Breakout Sessions, 1 New York Times bestseller, and you. QlikWorld Online, May 10-12: REGISTER 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
Kush
MVP
MVP

@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 😞