Make listbox from horizontal data / Excel

[#1]

Hi!

I have a problem and im a newbie! I have this Excel sheet with information, and i have made a graph with the data.

Making a listbox with the weeks are easy, but i also wanna have a listbox with the years. So i can see data for 2011 and 2013 for example.

But how do i make a listbox from horizontal data in Excel?

2008	2009	2010	2011	2012	2013
v.1	0	0	240	154	165	15
v.2	0	0	218	224	210	238
v.3	0	0	199	236	204	1851

[puttemans]

Think you should look into how to properly load a crosstable into Qlikview. That will allow you to have both informations readily available.

(in File Wizard, click on Table Files..., it will detect the Excel file, select 'embedded labels' under 'labels'. Then click 'next' twice and click on crosstabs. In your case, Qualifier fields=1, Attribute field = Year & data field= contents of your table)

[#3]

Okey yeah thats cool.

That gives me both listboxes.

But the graph now shows all years combined.

I wanna see each year seperated in the graph.

Thanks

[puttemans]

I got the years separately in a list box, with each time 3 different values (which should be correct)

I selected Year as a dimension in the chart properties, and =Sum(data) as the expression. When I select multiple years, it will show multiple years in the chart as well.

[#5]

Yes sorry, i also got the years spearately in the list box, but not in the diagram. Since we are Sum(data) the graph show all data together.

I wanna se a graph for each year. So if i mark say 2011, 2012, and week v.1 to v.3 I wanna see two different graphs to compare the difference between years.

thanks for the help!

[puttemans · Accepted solution]

If you select both Year and Weeks as dimensions, you should get what you're looking for.

regards,

[#7]

Yeah that works! Thx!