Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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!