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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
MikeC-12
Contributor II
Contributor II

Flipping X and Y axis values on a table (or pivot table)

Hello All,

Qlik newbie here.  I am trying to switch the x and y axis values. Here is what I currently have:

Before.PNG

Here is what I would like it to look like.  Currently these are my expressions I am using:

Dimension: =If(Week > CurrentWeek - 12 and Week <= CurrentWeek, Week)

Measure:  If (Week > CurrentWeek - 12 and Week <= CurrentWeek, Sum({<Year = {"$(=Max(Year))"} >}[My Value]))

after.PNG

Weeks could be on the bottom too. Thank you in advance for the help

0 Replies