Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to create a pivot table with custom dimension like this ?
You can use ValueList() function: QlikView ‒ ValueList - chart function
Could be just three expressions put horizontal, with a Year field dimension.
likj dis
or else try cross table
You can use ValueList() function: QlikView ‒ ValueList - chart function
Year as dimension....
3 Expressions : each point to a specific client.
Then drag to make year field horizontal.