topic Re: Table embebed in bar chart aligment in QlikView

Table embebed in bar chart aligment

Pedro_Rodriguez — Sat, 16 Nov 2024 21:08:05 GMT

Hi all,

I have a bar chart and I'd like o have some rows of data embebed under the bars as expression - Text on axis.

This works ok on my computer but once I generate the task on QMC and go through the web explorer, the aligment changes in the top chart, and in the second, the four rows go to one:

Local:

QMC:

I'd like to have all rows aligned (center if possible)

Please see attached.

Thanks a lot in advance!

Re: Table embebed in bar chart aligment

rubenmarin — Tue, 02 Apr 2019 20:03:58 GMT

Hi, If you can show the data stacked it will be centered

Re: Table embebed in bar chart aligment

Pedro_Rodriguez — Wed, 03 Apr 2019 09:51:38 GMT

It's true but unfortunately my client doesn't want the bars stacked. I'll have to come up with another solution.

Thaks anyway!

Re: Table embebed in bar chart aligment

rubenmarin — Wed, 03 Apr 2019 21:06:06 GMT

Another option is to create a transparent line and use dual() to set the text in a value below the minimum.

It also will need to set the static min of the chart.

I upload a sample to give the idea

Re: Table embebed in bar chart aligment

Pedro_Rodriguez — Thu, 04 Apr 2019 10:32:41 GMT

Thanks, that's it.
However I run into a new problem. I my real application, at least one of the expresions are Relative and because of that, it's the second part of the dual what is showing up instead.

But the solution is correct, thanks a lot!