topic linechart in QlikView

linechart

Tue, 15 Sep 2009 21:08:51 GMT

attached my question

Thanks

linechart

Tue, 15 Sep 2009 21:10:53 GMT

attached my excel-Diagramm

linechart

Tue, 15 Sep 2009 21:33:19 GMT

Take the property of your line chart.

Go to Axes

1.Uncheck the split axis option

2.Select the 'Sold To' expression

3.Change position to Left(Bottom)

linechart

Tue, 15 Sep 2009 21:40:10 GMT

Hi,

i understand what do mean.

can you make on my Qlickview.

Thanks

linechart

Tue, 15 Sep 2009 21:51:21 GMT

Document attached

linechart

Tue, 15 Sep 2009 22:02:56 GMT

Hi,

Thanks.

the data from Excel und QlikView is as same. in Excel is the y-axis Shipto relativ to SoldTo.

for example jan-2009 soldto = 2.9 and ship to = 2.15 and soldto is in y-acsis2.9 and shipto is 2.9+2.15=5.05

and shipto show 5.05.

how can i the same in Qlickview?

Thanks

linechart

Tue, 15 Sep 2009 23:49:00 GMT

Hi Shideh, Whether the table structure you have created is the original one, or is it simply created for showing a sample. Thing is that, the data model is wrong and hence the results are not valid.

Coming to your last question, it seems like the expressions you need are

1.sum(ShipTo)

2.sum(ShipTo) + sum(SoldTo)

linechart

Wed, 16 Sep 2009 13:40:36 GMT

Hi,

the data model is just for Test, i have yesterday created. my QlikView model is not the same.

Thanks, i think it is the expression that i need.

Thanks

linechart

Wed, 16 Sep 2009 13:49:40 GMT

Hi Ricky

i have another question.

how can i export the chart in Excel . when i export the chart, the chart isn't display in Excel, the date is display.

Thank for your Help

linechart

Wed, 16 Sep 2009 14:06:26 GMT

Hi, i didn'u understand what exactly you are looking for. Are you trying to export the chart values in qlikview to Excel? Right clicking on the chart and clicking 'Send Values to Excel' will export the values in a tabular format. If you want to display it as a graph itself, you Right Click-->Copy to Clipboard--> Image and paste it in your excel sheet.

linechart

Wed, 16 Sep 2009 14:11:49 GMT

Hi,

I want to display it as a graph itself. I tested know with copy to clipboard and it is Ok.

Thanks for your Help.