topic Re: Make listbox from horizontal data / Excel in QlikView

Make listbox from horizontal data / Excel

Thu, 30 Jan 2014 14:55:44 GMT

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

Re: Make listbox from horizontal data / Excel

puttemans — Thu, 30 Jan 2014 14:58:45 GMT

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)

Re: Make listbox from horizontal data / Excel

Thu, 30 Jan 2014 15:19:45 GMT

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

Re: Make listbox from horizontal data / Excel

puttemans — Thu, 30 Jan 2014 15:30:25 GMT

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.

Re: Make listbox from horizontal data / Excel

Thu, 30 Jan 2014 15:34:02 GMT

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!

Re: Make listbox from horizontal data / Excel

puttemans — Thu, 30 Jan 2014 15:37:42 GMT

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

regards,

Re: Make listbox from horizontal data / Excel

Fri, 31 Jan 2014 11:04:18 GMT

Yeah that works! Thx!