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]

To disable in the legend do as below:

[0li5a3a]

hi , doing that you would not display all the year months... I want to display

Jan,Feb,Mar, Apr, May, Jun, Jul,Aug, Sep, Nov, Dec even you you don't have data

[0li5a3a]

this doesn't work in my scenario. Please take the attached files and play with that.

[0li5a3a]

Hi ,

I want to display in the legend only the Success and Failed( bar chart) and in the pivot table  only Success and Failed Columns .

[nishanthi_8]

You can also play with the attached files so that you can also figure out.

[0li5a3a]

like I said your solution is not good. this could be a Qlik bug,

[0li5a3a · Accepted solution]

Hi All,

I come with the solution, this is want I need it.

Regards,

C

[0li5a3a]

[qlikviewwizard]

Hi constantin.olaru,

What you did? Please let us know.

I am using personal edition to verify.

[nishanthi_8]

Hope he disabled the legend and in case of "-" representation he made it to display as 0%