Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.