Skip to main content

New to Qlik Sense

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
srikanth1994
Contributor
Contributor

Average Function

Hi Qlik learners,

I have one scenario 

I want to calculate the average of field dived by another field 

Ex : D_CST_QUOTE_WI_DURATION_BD  dived by NUM_PRODUCTS   by month wise  dimension  is REPORTING_DATE

Condition is :

If(Upper(WORKITEM_NAME)='CSTQUOTEWI'
and Upper(WORKITEM_STATUS)='CLOSED',
(D_CST_QUOTE_WI_DURATION_BD/NUM_PRODUCTS)) as ALTER_CST_LEAD_TIME

this is the script i have written in backend 

When I have added this field ( ALTER_CST_LEAD_TIME) i want show average by monthwise in bar chart   but average is not matching with Excel average and Qlik Average  please help me

1 Reply
anat
Specialist II
Specialist II

can u share qlik and excel sample data  with expected output?