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

Ignore filter set analysis

Hello,

I have a chart that include the following measure:

Sum({<[Cellule]-={""},[oeeGroup]={"OEE100"}+{"OEE101"}+{"OEE900"}+{"OEE901"}+{"OEE153"}>}TOTAL stateTypeTime)

 

and I want to make sure oeeGroup can't be filtered anymore (Having those 5 values, and not removing any of them from the calculation), but I don't know how to do that... I tried :

Sum({<[Cellule]-={""},[oeeGroup]={"OEE100"}+{"OEE101"}+{"OEE900"}+{"OEE901"}+{"OEE153"},[oeeGroup]=>}TOTAL stateTypeTime)

Which resulted in no longer having the filtering for oeeGroup in the set analysis, so it's not the solution...

I also can't add a {1}, as I still need to use other filters on this chart...

 

Would greatly appreciate some help !

 

Antoine

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be like this?

Sum({<[Cellule]-={""},[oeeGroup]={"OEE100","OEE101","OEE900","OEE901","OEE153"}>}TOTAL stateTypeTime)

 

View solution in original post

2 Replies
tresesco
MVP
MVP

May be like this?

Sum({<[Cellule]-={""},[oeeGroup]={"OEE100","OEE101","OEE900","OEE901","OEE153"}>}TOTAL stateTypeTime)

 

Antoine
Contributor III
Contributor III
Author

Thank you ! It works just fine !