topic Line chart in QlikView

Line chart

Mon, 12 Mar 2012 11:03:21 GMT

Hello

somebody can tell me how to erase the gray sidebars of this line chart?

Thanks

Line chart

jjfabian — Mon, 12 Mar 2012 11:23:53 GMT

Hi Oronzo,

Try making your chart's background white in the colors tab of your chart.

Line chart

Mon, 12 Mar 2012 12:12:30 GMT

Hi Jakob,

my background is already white. It seems a problem with offset axis

Thanks

Oronzo

Line chart

jjfabian — Mon, 12 Mar 2012 12:48:14 GMT

In the style tab, try setting the plot area background style to minimal.

If your current setting was frame, then the color change would not do anything.

Line chart

Mon, 12 Mar 2012 13:40:15 GMT

Hi Jakob ,

if I change from frame to minimal I have always 2 sidebars white, I don't want to have sidebar

Thanks

Oronzo

Line chart

jjfabian — Mon, 12 Mar 2012 13:48:18 GMT

Ok, then also try setting the transparency of the frame background color to 100%

Now there should be no bars at all.

Line chart

Mon, 12 Mar 2012 14:05:55 GMT

Hi Jakob,

I have tried to do that, but I still haven't the desired chart.

I put in attachement what I'm looking for. I don't want to have the 2 areas with "NO"

Is it possible?

Line chart

jjfabian — Mon, 12 Mar 2012 14:17:12 GMT

QlikView is always going to render those areas left and right of the actual bar when your using a bar chart.

Maybe you can try using a gauge here instead and set it up in a manner that it fills to your value.

Re: Line chart

CELAMBARASAN — Mon, 12 Mar 2012 14:20:17 GMT

Hi,

Check whether you have used Backcast and Forecast options in the Axes tab if so then uncheck the both options.

Celambarasan

Line chart

Mon, 12 Mar 2012 14:25:47 GMT

Thanks for your answer but

Backcast and Forecast options are unchecked.

Oronzo

Line chart

CELAMBARASAN — Mon, 12 Mar 2012 14:29:19 GMT

Hi,

What type of chart are you using ?(Combo or line)

What is the height and width of the chart?

Celambarasan

Line chart

CELAMBARASAN — Mon, 12 Mar 2012 14:38:34 GMT

Hi,

Your chart size is large Qlikview automatically align to the center so it looks like gap before and after.

Celambarasan

Re: Line chart

Mon, 12 Mar 2012 14:41:18 GMT

Hello

So I can't moodify my chart..I suppose.

In attachement my qvw file

Re: Line chart

jjfabian — Mon, 12 Mar 2012 15:11:30 GMT

Hi,

it is pretty much like Celambarasan said, Qlikview will automatically align to the center so that the gaps will be there.

I've tried looking at your file. While it isn't particularly elegant, multiplying your line chart might give you the look of what you want. Basically it is two line charts on top of each other. The one that actually contains the chart is much larger an transparent, so it can see the scale of the second chart.

Maybe somebody has a more elegant solution that this?

Re: Line chart

Mon, 12 Mar 2012 15:42:43 GMT

Hi Jakob,

thank you for your answer. I cannot understand how the chart works:

1) Why the Used Dimension is '' ?

2) How can I use Legend ( I cannot flag Show legend in Presentation Tab)

Regards

Oronzo

Re: Line chart

jjfabian — Mon, 12 Mar 2012 15:53:08 GMT

Hi Oronzo,

1.) I used the calculated dimension "" so I would have a dimension on the axis. That way I could perfectly align both axes.

2.) You have to understand what I did here to achieve this. I made second object and put it on top of the other one. So it matters greatly where you click in order to activate a legend for "the right" object 🙂

I changed the bordes of the large object, so you can see where I positioned it.

I used CTRL + Arrow Buttons to move it into the correct position. I also activated the legend for you. To get it into this position I held CTRL + SHIFT after clicking into the object, which lets me move the individual components around. (You should see red outline of the objects)

I've attached the new file for you, oHpe you can navigate around in it.

Jakob

Re: Line chart

Tue, 13 Mar 2012 08:45:47 GMT

Thank you are great qlikview MAN

Oronzo