topic Help with simple table in QlikView

Help with simple table

Tue, 05 Aug 2014 09:44:50 GMT

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 — Tue, 05 Aug 2014 09:55:03 GMT

Hoi Paul,

Please use pivot table in this case.

Thanks

Tue, 05 Aug 2014 10:02:36 GMT

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

Tue, 05 Aug 2014 10:13:06 GMT

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