topic Display missing bars in a bar chart in QlikView

Display missing bars in a bar chart

manideep78 — Wed, 24 Aug 2016 10:10:57 GMT

Dear Community,

I wanted to show the bar chart with 2 dimensions like a below image:

But here, for the first dimension some values are missing in second dimension (marked in the red circle) and it show empty with out even showing a zero value.

can you please suggest me know how can I display the missing second dimension with 0 value.

any help would be appreciated.

Thanks in advance.

Regards,

Manideep

Re: Display missing bars in a bar chart

sunny_talwar — Wed, 24 Aug 2016 10:14:38 GMT

Try checking Zeros on bar on the presentation tab. Also make sure that Suppress Zero Values is unchecked

Re: Display missing bars in a bar chart

manideep78 — Wed, 24 Aug 2016 10:17:49 GMT

Hi Sunny,

Thanks for the quick reply. I tried every possible option but no luck.

Regards,

Manideep

Re: Display missing bars in a bar chart

sunny_talwar — Wed, 24 Aug 2016 10:19:13 GMT

How about if you add + Avg({1} 0) to your expression? and then follow the above directions?

Re: Display missing bars in a bar chart

manideep78 — Wed, 24 Aug 2016 10:22:49 GMT

Still the issue remains same Sunny.

Regards,

Manideep

Re: Display missing bars in a bar chart

sunny_talwar — Wed, 24 Aug 2016 10:25:34 GMT

Would you be able to share a sample?

Re: Display missing bars in a bar chart

manideep78 — Wed, 24 Aug 2016 10:35:52 GMT

Hi Sunny, here is my sample app. !

Re: Display missing bars in a bar chart

sunny_talwar — Wed, 24 Aug 2016 10:39:55 GMT

I guess the issue is that the dimension is not just null, but it is missing. I think, you will need to add those missing dimensions back in order to make this to work.

Re: Display missing bars in a bar chart

thakkarrahul01 — Wed, 24 Aug 2016 10:44:18 GMT

Hi Manideep,

Along with what stalwar1‌ Sunny T suggested can you try modifying expression as in QlikSense Dimension: show all values like QlikView?

Re: Display missing bars in a bar chart

manideep78 — Wed, 24 Aug 2016 10:46:53 GMT

Yes, It is not null, but it is missing.

Re: Display missing bars in a bar chart

sunny_talwar — Wed, 24 Aug 2016 10:50:45 GMT

I guess none of the techniques mentioned above won't work with missing data. you will have to convert missing data into null data to make this to work. Having said that, I would encourage you to seek other people advice, because I may not know if there is a way to do this. May be someone have a way to figure this out, but I am not aware of any way to do this

Re: Display missing bars in a bar chart

manideep78 — Wed, 24 Aug 2016 10:53:40 GMT

That's great Sunny. Thanks. I appreciate your help!

Re: Display missing bars in a bar chart

manideep78 — Wed, 24 Aug 2016 10:54:25 GMT

Hi Rahul,

I tried this expression already and found no luck.

Regards,

Manideep

Re: Display missing bars in a bar chart

MarcoWedel — Wed, 24 Aug 2016 23:35:30 GMT

Hi,

maybe one solution might be:

hope this helps

regards

Marco