Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
jglenn87
Contributor
Contributor

Day of the week format in Pivot table

Hello,

I am trying to align a pivot table by Day of the Week in a Sunday - Saturday format. Is there an expression that can be used to achieve this? Currently this is the format that is coming up.

2020-01-16_9-28-55.jpg

 

1 Reply
Tiago_Valls
Contributor II
Contributor II

Hello, my sugestion in this case is not use a calendar table. 

In this case, use a weekday function with the date , so qlik will sort automatically.