topic Show values in a bar chart in Qlik Automate

Show values in a bar chart

alexdelagarza — Tue, 25 Feb 2025 05:39:42 GMT

Hello everyone!

I'm struggling with something that should be quite simple, or at least that's what a thought till now, I have two expressions in a bar chart, and I need to show the values of both expresions, so, I enable the option 'show data values' (Mostrar valores sobre los datos) in the first expression and the values are shown, but when I enable the second expression the values disapear in both expressions. Why??

Best!

Re: Show values in a bar chart

JandreKillianRIC — Tue, 25 Feb 2025 07:23:17 GMT

HI @alexdelagarza

Its working on my side

Perhaps try rebuilding the whole chart?

Regards - Jandre

Re: Show values in a bar chart

alexdelagarza — Tue, 25 Feb 2025 21:37:05 GMT

Hi @JandreKillianRIC

I did it, I built the whole table from the begining but nothing.

But I filter just around 5-6 weeks instead of all the weeks (53) of the year, and the values are shown for both expressions.

So, I tried changing the number of maximum shown values and it worked.

I still have to change the position of the label to the Top/Bottom of the bars because thera some labels that are still hide, but, I don´t know how to do it.

Best!

Re: Show values in a bar chart

marcus_sommer — Wed, 26 Feb 2025 15:17:49 GMT

If there isn't enough space within the bar the value won't be shown. You may tick the vertical option and/or moving the values on the outside of the bars. You may also play a bit with the sizes of the bars and the fonts and/or enabling a scroll-bar to the weeks or similar stuff.

Alternatives may be to include another expression - with hidden bars/lines and axes, for example with argb(0,0,0,0) - in the chart and enabling for it the show values. Also a second/third chart overlapping/underlying the origin one with appropriate adjusted properties is sometime helpful.