topic Re: Bar Chart Values Formattimg in QlikView

Bar Chart Values Formattimg

waqasshah — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I am developing a chart but I am facing difficulty in the formatting of values along X axis. Please review the attached screen short. I want the values to be displayed under the bar like 2017 should come under centrally green bar and 2016 centrally under blue. I want the year value centrally formatted.

Thanks in advance

Kind Regards

Waqas Shah

Re: Bar Chart Values Formattimg

arvind_patil — Thu, 12 Oct 2017 10:41:57 GMT

HI Waqas,

Go to properties -> colors

And change first two colors as you want:

Thanks,

Arvind Patil

Re: Bar Chart Values Formattimg

waqasshah — Thu, 12 Oct 2017 10:44:30 GMT

Thanks Arvind

I think you misunderstood my question. I want the values should display under the bar chart not on the sides of the bar. 2017 centrally formatted . Currently it is displaying on right hand side of the green bar .

Re: Bar Chart Values Formattimg

Anil_Babu_Samineni — Thu, 12 Oct 2017 10:48:12 GMT

I am assuming, you have 2 measures. Which one measure allocation to Null values so then The diagonal of X-axis values showing right side. And, Can you adjust using Ctrl + Shift to change the graphs

Re: Bar Chart Values Formattimg

waqasshah — Thu, 12 Oct 2017 11:13:26 GMT

Thanks Anil Ctrl +Shift wont work

Yes I have 2 expressions. how can I make the value in centre?

Re: Bar Chart Values Formattimg

waqasshah — Thu, 12 Oct 2017 11:24:51 GMT

Dear Tarrel,

I cannot view your reply. Following message is appearing.

Access to this place or content is restricted. If you think this is a mistake, please contact your administrator or the person who directed you here.

Kind Regards

Waqas Shah

Re: Bar Chart Values Formattimg

Anil_Babu_Samineni — Thu, 12 Oct 2017 11:32:00 GMT

The only option is change the Look from Style Tab and use the last one which is curvy to each graph. And then see? Or you need to work for Null handling which is required to suppress

PFA for referenece

Re: Bar Chart Values Formattimg

waqasshah — Thu, 12 Oct 2017 11:49:59 GMT

Dear Anil

Many thanks for your help. Actually if I use style option then that will effect my other charts. Can you please tell me how to use the other option

to work for Null handling which is required to suppress

Kind Regards

Waqas Shah

Re: Bar Chart Values Formattimg

Anil_Babu_Samineni — Thu, 12 Oct 2017 11:59:32 GMT

Let's talk first one now, Do you mean to say the visualization is not good between from others? Or what.

Re: Bar Chart Values Formattimg

waqasshah — Thu, 12 Oct 2017 12:16:23 GMT

Yes the requirement is visualisation should be same on dashboard. all charts should have same format and colours as well. so I cant change the style