Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
joshabbott
Creator III
Creator III

Supress Null of Second Dimension in Chart - Show all first dimensions

Hello,

I'm attaching an example of what I want, because it may be hard to explain.  I have 2 dimensions in a chart (a and b).  There are only 2 records in the table right now:

dimension a:

A

B

dimension b:

1

null

expression

1

null

The following is just a test, but dimension a and dimension b values are dynamic (the number of values could be 1-x), it isn't fixed like in the example.  I want to show all of dimension 'a' to show in a chart, but I only want values of dimension 'b' to show if they aren't null.  So in the example, I want to see 'A' and 'B' across the bottom of the chart, but for dimension 2, I only want to see '1', I want to eliminate the null value.

Thank you for any help you can give me!

Josh

0 Replies