New to Qlik Analytics

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

Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!

Who Me Too'd this topic

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)
Who Me Too'd this topic