Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating a graph for weekly view

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.

3 Replies
Josh_Good
Employee
Employee

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

jagan
Luminary Alumni
Luminary Alumni

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.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Close this discussion if you find the solution.

Regards,

Jagan.