Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
aditi_haldule
Contributor III
Contributor III

How to add set analysis for dimensions

Hi,

I have some products on X axis (dimension)and their values on Y axis on a bar chart. I want to show all the values on X axis and exclude one product- so that on X axis all the products are show except for 1 which I dont want to show. Is there a way I can do that? Maybe set analysis?

12 Replies
aditi_haldule
Contributor III
Contributor III
Author

Hi, yes that was a mistake. Now I'm able to see 4 bars on X axis which dont include NC but one of them comes in gray without a label. But their total still gives me the exact value of sales except NC. I'll figure out about that one gray bar in the bar chart hopefully. Thanks a lot! 🙂

salonicdk28
Creator II
Creator II

That grey bar is of null values, if you uncheck that option from your dimension then that will also go away

salonicdk28_0-1615552257255.png

 

If you get your answer then please accept that as solution

Thanks

aditi_haldule
Contributor III
Contributor III
Author

Yes perfect! Done!

Thank you so much 🙂