Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Employee
Employee

Re: Creating a graph for weekly view

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

MVP
MVP

Re: Creating a graph for weekly view

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.

MVP
MVP

Re: Creating a graph for weekly view

Hi,

Close this discussion if you find the solution.

Regards,

Jagan.

Community Browser