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

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
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

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

4 Replies
swuehl
Champion III
Champion III

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
MVP
MVP

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.