Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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?