linechart

[#1]

Hi

attached my question

Thanks

[#2]

attached my excel-Diagramm

[#3]

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)

[#4]

Hi,

i understand what do mean.

can you make on my Qlickview.

Thanks

[#5]

Document attached

[#6 · Accepted solution]

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

[#7]

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)

[#8]

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

[#9]

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

[#10]

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.