Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Help with simple table

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

fore.PNG.png

1 Solution

Accepted Solutions
Highlighted
Not applicable

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

3 Replies
Highlighted
Specialist
Specialist

Hoi Paul,

Please use pivot table in this case.

Thanks

Highlighted
Not applicable

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

Highlighted
Not applicable

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