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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Tommmy
Contributor III
Contributor III

How to create fix value KPI?

Hi experts

I need to create a fix value KPI, not changing when a dimension value is filtered/selected.

Here is my formula, a division of 2 parts, but not working:

Sum({1}{<CostCenter={'4500', '4510', '4520', '4530'}>} amount)

/

Sum({1}{<CostCenter={'4540'}>} amount)

 

Any ideas how to get this KPI fix / static?

Thanks, Tom

Labels (5)
2 Replies
Lisa_P
Employee
Employee

Should be:

Sum({1<CostCenter={'4500', '4510', '4520', '4530'}>} amount)

/

Sum({1<CostCenter={'4540'}>} amount)

Tommmy
Contributor III
Contributor III
Author

Thanks

This works but it shows a wrong value instead without thie "1".

Any ideas?