Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Changing Sequence of Dimension & Expression

Hi,

Is it possible to put dimension in between expressions. For e.g.I have a pivot table with 3 dimensions and 5 expressions.

DIM1

DIM2

DIM3

EXP1

EXP2

EXP3

EXP4

EXP5

In the pivot table, can I have this sequence; (the order in which they appear in the table):

DIM1

EXP1

EXP2

EXP3

DIM2

DIM3

EXP4

EXP5

We have to stick with this sequence because the excel extract from this report is used as an input to another system which expects the order of the fields to be like this.

Thanks,

Abey

1 Reply
Highlighted
Specialist II
Specialist II

As I remember, you can't do it with Pivot. but it's possible with straight table chart.