Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ross1991
Contributor III
Contributor III

KPI for Selected Month

Date      Parts Produced

Feb               50

Feb               100

March           100

March            200

I have a table just like above.  Can someone please tell me what formula I need to put on KPI measure field to just get month of Feb?  It should display 150.    The formula I had used previously did not work in this table,  but previously my table had 3/3/24 date format.  I had used Sum({<Date={"=Month(Date)=3"}>}[Parts Produced])

This formula did not work for above table.  Please help! Thank you.

 

Labels (1)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

Sum({<Date={Feb}>}[Parts Produced])

View solution in original post

2 Replies
Lisa_P
Employee
Employee

Sum({<Date={Feb}>}[Parts Produced])

Ross1991
Contributor III
Contributor III
Author

Thanks.   It worked.