topic Re: Chart with two line dimension in QlikView

Chart with two line dimension

Thu, 27 Mar 2014 12:21:32 GMT

Hello ,

Is it possible to do a dimension with two line on chart ?

Thanks in advance

Re: Chart with two line dimension

sudeepkm — Thu, 27 Mar 2014 12:40:37 GMT

Do you want to split the ZZZ into two bars?

If so then can you please provide the conditional logic based on which you want to split it

Re: Chart with two line dimension

Thu, 27 Mar 2014 12:51:43 GMT

You can create one expression and add two dimensions to a Line chart. For example you can have dimensions as Year and City and expression as Sum(Sales). Then you will see Year in x-axis and one line for each City. Line represents the Sales for the particular City.

Does that answer your question?

Re: Chart with two line dimension

maxgro — Thu, 27 Mar 2014 23:57:34 GMT

if you want two bars (you asked for lines; lines = bars?) in the chart you posted just add another expression

if you want a line chart with 2 lines you need 2 expression and a line chart (change from bar to line in first tab, general)

Re: Chart with two line dimension

Fri, 28 Mar 2014 09:55:29 GMT

Hi All,

I want to show the name of 'Category' in two lines. A bar will stay one.

e.g.

ZZZ I would \ ________________________

like to /

Re: Chart with two line dimension

sudeepkm — Fri, 28 Mar 2014 10:10:49 GMT

I think in a bar chart you cannot wrap the dimension field values. I'll further check and confirm it to you.

Re: Chart with two line dimension

Fri, 28 Mar 2014 10:15:32 GMT

Thanks sudeepkm

Much appreciated

Re: Chart with two line dimension

Mon, 31 Mar 2014 12:09:14 GMT

There is no way to wrap the text. Your only real options are either to make the font smaller, or un-tick "Truncate Label" in which case the label will continue writing over the bottom of the graph. If you hold down Ctrl & Shift after selecting the graph, you can also shrink the graph size so you have more room for the axes to display.

Re: Chart with two line dimension

Mon, 31 Mar 2014 12:43:25 GMT

Hi Byron,

I did Ctrl & Shift but it's looking not nice.

Where can I find "Truncate Label" ?

Re: Chart with two line dimension

Mon, 31 Mar 2014 12:47:20 GMT

You can find it under Axes - See highlighted below. There really isn't a great answer to what you are looking for. Sometimes I just drop the font size as much as possible

Re: Chart with two line dimension

Mon, 31 Mar 2014 12:58:12 GMT

ByronGRFoxthanks for your answer but I don't have this option in my 'Axes'.

I will try front and Ctrl & Shift.

Re: Re: Chart with two line dimension

sudeepkm — Tue, 01 Apr 2014 09:20:39 GMT

OK. There is a way but not using BAR chart. Use a straight table. Please take a look at the example attached.