Nulls In Pivot Table and Bar Chart

[0li5a3a]

Hi all,

Could someone advise me how to DON'T display the  " -" into the Pivot Table and Bart Chart?

I want to mention that I still want to display the Months with no data in it but I don't want to see this " - " in the legend in the Bart Chart and in Type in the Pivot Table.

Please find the attached files where I have created a scenario.

Kind regards,

[nishanthi_8]

Use "suppress when value is null" at the dimension level

[0li5a3a]

Hi ,

If you do that and select for example year 2017 or 2018 the months which has not tickets they would not be displayed and I want to display all.

Regards, 

[nishanthi_8]

Ok your concern is it shouldnt display '-' in the legend and chart but instead of that any valuable message like 'Not Available'. Is that what you mean ?

[kfoudhaily]

hello,

you need to change the null value highthed in the screen shot to whatever you need

[nishanthi_8]

Yes I was about to mean the same thing. I hope this would solve your requirement Constantin

[0li5a3a]

hi guys, could you please try to do this in the test app from the above ?

[nishanthi_8]

Certain fields I am not able to visualize... Like Year and the other fields are disabled. Can you please elaborate your requirement ?

[kfoudhaily]

here it is

[qlikviewwizard]

Hi Try like this.