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: 
Anonymous
Not applicable

custom dismension

How to create a pivot table with custom dimension like this ?

Sans titre.png

1 Solution

Accepted Solutions
4 Replies
swuehl
MVP
MVP

Could be just three expressions put horizontal, with a Year field dimension.

Chanty4u
MVP
MVP

  1. NewTable: 
  2. LOAD * INLINE [ 
  3.     Header1, Header2, Header3 
  4.     delivered, , 
  5.     opened, , 
  6.     landing_page_hits, , 
  7.     sign_up, , 
  8.     completions, , 
  9. ]; 

likj dis

or else try cross table

sunny_talwar

You can use ValueList() function: QlikView ‒ ValueList - chart function

Not applicable
Author

Year as dimension....

3 Expressions : each point to a specific client.

Then drag to make year field horizontal.