topic Re: How to align 2 chart in QlikView

How to align 2 chart

Anonymous — Wed, 09 Nov 2016 13:58:41 GMT

Hi,

i have a problem with the alignment of 2 different chart.

As you can see in the image, days are not vertically align because the legend.

Can i force legend to be shown even if had just 1 expression ?
I have tried a workaround like adding an invisible expression set to 0 ... works but when i export values in Excel the 0 expression is shown.

Are there other methods ?

Re: How to align 2 chart

rubenmarin — Wed, 09 Nov 2016 14:04:14 GMT

Hi Luca, you can click the second chart (to active the object) and pressing CTRL+MAYS you'll see a red lines, those lines limits the chart area, you can manually set the widht similar to the upper chart.

Most probably the upper chart should be manually limited too, because if you left the default auto-widht it can vary based on the legend strings.

Re: How to align 2 chart

sunny_talwar — Wed, 09 Nov 2016 14:06:18 GMT

You can add a dummy expression with a very small value and then make it invisible. Also make sure you have selected Stacked on the Style tab

Re: How to align 2 chart

rubenmarin — Wed, 09 Nov 2016 14:13:23 GMT

Good tip Sunny, I will try to remember this.

Unfortunatly I tried and still exports the expression to excel wich surprised me. I don't know if I'm doing something wrong but maybe a workaround to hide the export to excel is add the expression like:

label: =' '

Expression: Dual(' ', 0)

So it exports a blank column to excel

Re: How to align 2 chart

sunny_talwar — Wed, 09 Nov 2016 14:16:22 GMT

You know, I did not read the whole thread by OP and responded. Since he already tried that, my response was basically redundent. But ya what you proposed can definitely be tried.