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 Label Change

Sum({$<[Sale History 2022.Customer]={"Publix"}>}[2022 Qty Sold])

Ross1991_0-1716062035616.png  Can someone please tell me, how to make KPI label change based on what is in the formula?  If formula above says, "Petco", I need to see KPI with 10,000 and Label says "PETCO". Is this possible?  Thank you.

 

Labels (1)
2 Replies
pravinboniface
Creator II
Creator II

I don't fully understand how you will change what's in the formula- I would think you will use a variable in your formula like $(vStoreName) and that will have either "Publix" or "Petco".  You will use that same variable wherever you want it to be in effect.

Hope that helps!

Ross1991
Contributor III
Contributor III
Author

Thanks. I will try. Still learning about Variables.