Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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.