Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Which Chart to Use to Create Excel Like Table

Hi All

I could do with a little help as to which chart to use:

I need to create the equivalent of and excel table

1 Axis = Names (down the left)

1 Axis = Starting date of Each Week (across the top)

Intersection = sum(timespent)

I have tried the pivot table but its not what i am looking for.

Any other suggestions?

Thanks

JP

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Which Chart to Use to Create Excel Like Table

Hi JP,

Pivot table should do if you pivot the dimension corresponding to the Starting date of each week to the top, by holding the mouse in the dimension column until you see a big blue arrow and dragging it to the top of the chart, when the arrow points to the left horizontally.

Did you try that?

Miguel

2 Replies
MVP
MVP

Which Chart to Use to Create Excel Like Table

Hi JP,

Pivot table should do if you pivot the dimension corresponding to the Starting date of each week to the top, by holding the mouse in the dimension column until you see a big blue arrow and dragging it to the top of the chart, when the arrow points to the left horizontally.

Did you try that?

Miguel

Not applicable

Re: Which Chart to Use to Create Excel Like Table

Hi Miguel

Thanks a mil, exactly what I was looking for. I didn't know you could do that, so I was stuck with the everything in 1 axis.

Best

JP

Community Browser