Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik_Student
Contributor
Contributor

How to show weeks as columns with total sales

Hello All,

This is my first question, I have limited experience, but I am open to any advise and good practices to expand my knowledge.

My question as the subject suggests, how can I show total sales (turnover) by week for each sales dept?

Displaying the weeks as individual columns.

Sample of report below of how it should look.

Qlik_Student_0-1702362391435.png

 

Labels (2)
1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Create a Pivot Table.

Check this video.

https://www.youtube.com/watch?v=1japJ6uj4js&t=135s

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!