Hiattached my questionThanks

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.05and shipto show 5.05.how can i the same in Qlickview?Thanks

Hi Rickyi 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

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

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.

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 are1.sum(ShipTo)2.sum(ShipTo) + sum(SoldTo)

Hi,i understand what do mean.can you make on my Qlickview.Thanks

Take the property of your line chart. Go to Axes1.Uncheck the split axis option2.Select the 'Sold To' expression3.Change position to Left(Bottom)

linechart

Qlik.com | Qlik Services | Qlik Help

Ask a Question

attached my question

Thanks

10 Replies

Author

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.

linechart

QlikView App Dev

Related Topics