Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
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