how the data should look like to be useful ?

[#1]

how the data should look like to be useful ?

[prma7799]

Didn't get you can you explain more?

[#3]

for example, i have an excel workbook has two sheets sales of 2013 & 14, but i show me only the one for 2014,should it be in one sheet for example ? , i want to make comarison between these two years ?

thank for your respond any how.

[tyagishaila]

Load both sheets in qlikview

then You can compare easily.

[#5]

Hi,

As you said,you have  excel file with two sheets ,having 2013 and 2014 sales data.

you can load both the sheets in qlikview

and then can campare it.

eg

Thanks

Sudhanshu shrivas

[saumyashah90]

1)Load Data from excel into QlikView as mentioned above

2)Once done Reload the file.

3)there are two ways by which you can represent it nicely is Bar chart and Line Chart

also using stacked chart and combo chart

Also layer charts

[#7]

is it a proplem if the fields in both sheet have the same names ?

Thanks

Moh-ElAwady

[#8]

With all fields the same name, QV will auto concatenate into a single table for you. Should then be fine for you to create required charts from there.

In this instance it sounds like just yea on year data, so it is best to be in a single table really.

[tyagishaila]

if the fileld name and values are same than it is good, qlikview itself associate these fields.

but if you don't want to associate you can use Noconcatenate.

What you actually want to calculate.

[#10]

if the fields are same in the two tables ,whenever we load that two tables it displays the synthetic key or association in the table viewer.