Skip to main content

New to Qlik Sense

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

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
Aitelli_805
Contributor II
Contributor II

splash page

In master item filter I have integrater server which has true, false. I need to show which total of true which are present and total kw. I'm using the climber kpi  for dimension i have sum(power_kw), sum('present') count integrated server. Not sure what logic to used to calculated 

  • TOTAL INSTALLED - - Plus Total KW (TKW)
1 Solution

Accepted Solutions
ToniKautto
Employee
Employee

Set expression allow you to alter the aggregation scope, for example:

sum({<MyFlag={"true"}> MyField}

Note, the exact format depends on your data model and flag fields. 

 

View solution in original post

1 Reply
ToniKautto
Employee
Employee

Set expression allow you to alter the aggregation scope, for example:

sum({<MyFlag={"true"}> MyField}

Note, the exact format depends on your data model and flag fields.