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: 
Ross1991
Contributor III
Contributor III

If Statement

Ross1991_0-1715650492596.pngRoss1991_1-1715650673362.png

Can anyone please tell me what If statement I need to use in Bar Chart measure, where Count only shows "BRKDWN"?     I need Barchart to ignore "PM".     A036 machine needs to be 2 as shown above.   Thank you.

Labels (1)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

{<[WO Type={BRKDWN}>}Sum([Down Time]

The Set analysis part of the expression (inside the { }) shows the scope of the aggregation following

 

View solution in original post

2 Replies
Lisa_P
Employee
Employee

{<[WO Type={BRKDWN}>}Sum([Down Time]

The Set analysis part of the expression (inside the { }) shows the scope of the aggregation following

 

Ross1991
Contributor III
Contributor III
Author

Thank you.   I got it for both Count and Sum.