Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.