topic Re: Creating a graph for weekly view in QlikView

Creating a graph for weekly view

Thu, 19 Sep 2013 14:43:16 GMT

I have a table with the entity in one column, and then 53 columns for each week.

How can I create a chart with the weeks along the x-axis and the different entities in the graph???

Is it also possible to get these weeks in a list box so they can be selected? even though they are different columns?

Thanks for any help in advance.

Re: Creating a graph for weekly view

Josh_Good — Thu, 19 Sep 2013 14:55:03 GMT

You should load the data using a cross table. This will transform the data so it is three columns, your first entity, the week and the data. Here is a video that shows how to use the cross table function.

http://www.youtube.com/watch?v=qHu45iWamL8

Re: Creating a graph for weekly view

jagan — Thu, 19 Sep 2013 15:08:15 GMT

Hi,

Use Crosstable() to convert week columns to rows and you just use Week column as dimension in the chart. Refer CrossTable() example in Help file.

Hope this helps you.

Regards,

Jagan.

Re: Creating a graph for weekly view

jagan — Fri, 20 Sep 2013 14:53:42 GMT

Hi,

Close this discussion if you find the solution.

Regards,

Jagan.