Null Values Not Getting Suppressed

[#1]

I have two dimensions Year and Names, I have selected suppress null values under dimensions and Suppress zero values under Presentation. However, in the attached QVW, charts are still showing the Year with blank values and Names with the null values. Please assist.

Thanks!

Nidhish Khare

nidhish.khare@gmail.com

[Gysbert_Wassenaar]

You're using two dimensions on the same axis. In Qlikview space is always reserved for each combination of the two dimension values in such cases. If you don't want this you have to use only one dimension. You could try using a calculated dimension like = [Instructor] & ' - ' & [Quality_Year].

[#3]

Thanks Gysbert!

This will solve the problem, but will create one more issue, that the names and years will appear multiple times for each combination review the attached screenshot for the same.

Thanks!

Nidhish Khare

[Gysbert_Wassenaar · Accepted solution]

Change the Subtype setting on the Style tab to Stacked.

[#5]

This will change the view a bit but will certainly solve the problem, thanks Gysbert for the quick help really appreciate it!