Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

New Qlik Sense How do I sum of rack units with power kw

How do I calculated a total of rack units which are planned in the data center plus total kw? Planned meaning which are in the system but not install yet but the power are know by the model .  I'm using simple KPI measure. Please see attachment.

=sum(if(itemstate='Planned' and integrated_rack='True', power_kw, 0))

1 Reply
Partner - Master III
Partner - Master III

Use set analysis.

something like below
sum({<itemstate={'Planned'} , integrated_rack={'True'}>}
if you share a sample app can help further