topic Re: Nulls In Pivot Table and Bar Chart in QlikView

Nulls In Pivot Table and Bar Chart

0li5a3a — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: Nulls In Pivot Table and Bar Chart

nishanthi_8 — Mon, 09 Jul 2018 09:33:34 GMT

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

Re: Nulls In Pivot Table and Bar Chart

0li5a3a — Mon, 09 Jul 2018 09:42:11 GMT

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,

Re: Nulls In Pivot Table and Bar Chart

nishanthi_8 — Mon, 09 Jul 2018 09:49:35 GMT

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 ?

Re: Nulls In Pivot Table and Bar Chart

kfoudhaily — Mon, 09 Jul 2018 09:51:47 GMT

hello,

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

Re: Nulls In Pivot Table and Bar Chart

nishanthi_8 — Mon, 09 Jul 2018 09:54:13 GMT

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

Re: Nulls In Pivot Table and Bar Chart

0li5a3a — Mon, 09 Jul 2018 10:02:33 GMT

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

Re: Nulls In Pivot Table and Bar Chart

nishanthi_8 — Mon, 09 Jul 2018 10:13:59 GMT

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

Re: Nulls In Pivot Table and Bar Chart

kfoudhaily — Mon, 09 Jul 2018 10:15:24 GMT

here it is

Re: Nulls In Pivot Table and Bar Chart

qlikviewwizard — Mon, 09 Jul 2018 10:20:54 GMT

Hi Try like this.

Re: Nulls In Pivot Table and Bar Chart

nishanthi_8 — Mon, 09 Jul 2018 10:21:52 GMT

To disable in the legend do as below:

Re: Nulls In Pivot Table and Bar Chart

0li5a3a — Mon, 09 Jul 2018 10:54:24 GMT

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

Re: Nulls In Pivot Table and Bar Chart

0li5a3a — Mon, 09 Jul 2018 10:56:12 GMT

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

Re: Nulls In Pivot Table and Bar Chart

0li5a3a — Mon, 09 Jul 2018 10:59:22 GMT

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 .

Re: Nulls In Pivot Table and Bar Chart

nishanthi_8 — Mon, 09 Jul 2018 11:06:49 GMT

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

Re: Nulls In Pivot Table and Bar Chart

0li5a3a — Mon, 09 Jul 2018 12:01:57 GMT

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

Re: Nulls In Pivot Table and Bar Chart

0li5a3a — Mon, 09 Jul 2018 13:40:15 GMT

Hi All,

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

Regards,

Re: Nulls In Pivot Table and Bar Chart

0li5a3a — Mon, 09 Jul 2018 13:41:22 GMT

Re: Nulls In Pivot Table and Bar Chart

qlikviewwizard — Tue, 10 Jul 2018 04:50:00 GMT

Hi constantin.olaru,

What you did? Please let us know.

I am using personal edition to verify.

Re: Nulls In Pivot Table and Bar Chart

nishanthi_8 — Tue, 10 Jul 2018 12:25:51 GMT

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