topic Which Chart to Use to Create Excel Like Table in QlikView

Which Chart to Use to Create Excel Like Table

Mon, 11 Jun 2012 13:28:22 GMT

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

Which Chart to Use to Create Excel Like Table

Miguel_Angel_Baeyens — Mon, 11 Jun 2012 13:39:11 GMT

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

Re: Which Chart to Use to Create Excel Like Table

Tue, 12 Jun 2012 09:52:03 GMT

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