Discussion Board for collaboration related to Creating Analytics for QlikView.
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
Thanks I am using a pivot table and just see you can drag dimension over to horizontal and keep other dimension over to vertical.
View solution in original post
Please use pivot table in this case.
Yeah. You will have to use a privot table for this request.
You cannot move dimensions horizontally in a straight table.