Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-12-27 07:47 PM

#1 KPI with "SUMPRODUCT" Formula

Dear all,

I would like to create a #1 KPI to show Monthly Average Number as in the blue box in the print screen as well as a Yearly Average Number in the Red Box.

Print screen.PNG

Actual calculation formula are as attached in the excel.

Thank you very much in advance for your assistance!

Cheers and Happy New Year!

訊息由此人編輯：Woon Han Yap

SUMPRODUCT Test.xlsx
1,142 Views
0 Likes
2 Replies
MK9885
Master II
Master II
‎2017-12-28 09:00 AM

You are missing the attachment with your question.

1,012 Views
Anonymous
Not applicable
‎2017-12-28 08:05 PM
Author

In response to MK9885

Thank you SKhan for your reply.

I had reattached again. Happy New Year!

1,012 Views
0 Likes