Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Kirsten
Creator II
Creator II

Exclude bar (of unclassified metrics) in barchart

Hi,

I currently have a barchart with unclassified metrics and would like to hide these. The other bars are based on a join (match) between 12NC and PPG. But some could not be matched and are now visible in the gray barchart. Is it possible to have this exclusion excluded in the expression as visible in image 2?

I can currently have it removed by turning on the filter of all PPG's  but then my filter can not be used in an interactive way anymore.

Kirsten

 

Labels (1)
1 Solution

Accepted Solutions
dwforest
Specialist II
Specialist II

Uncheck Show Null on dimension?

View solution in original post

4 Replies
Wlad_Masi
Employee
Employee

Hello @Kirsten 
I did not find any image attached to this post, do you mind sending it again, please?

If I understood it correctly would the option "Show others" unchecked address your problem?

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
dwforest
Specialist II
Specialist II

Uncheck Show Null on dimension?

Kirsten
Creator II
Creator II
Author

Hi @Wlad_Masi 

Yes in the meantime I figured out. It indeed worked out with unchecking "include null values" under Data/Dimensions

Thanks for the support!

Kirsten

 

Kirsten
Creator II
Creator II
Author

Hi @dwforest 

If you mean unchecking "include null values" under dimension that indeed worked