Help with simple table

[#1]

Hi All,

I have been using Qlik view for a while but I am struggling with what seems a fairly simple request.

I need to create a forecast table which has products listed vertically qty forecast but by production week horizontally across the table.

I have set up a master calendar with Production weeks so that is all fine.  Here's the kind of thing we do in excel:

Any suggestions would be very helpful

[deepakqlikview_123]

Hoi Paul,

Please use pivot table in this case.

Thanks

[#3 · Accepted solution]

Thanks I am using a pivot table and just see you can drag dimension over to horizontal and keep other dimension over to vertical.

[#4]

Hi Paul,

Yeah. You will have to use a privot table for this request.

You cannot move dimensions horizontally in a straight table.

Regards,
Marius