Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.