topic Re: Expression coulmn in pivot table before dimension in QlikView

Expression coulmn in pivot table before dimension

Mon, 01 Dec 2014 07:20:57 GMT

Hi All,

Is it possible to change the location of the expression in pivot table? lets say to if my expression is in the last column, can I change it to be the first column? (before the first dimension or between the first and the second dimensions.....)??

Thanks

Re: Expression coulmn in pivot table before dimension

lironbaram — Mon, 01 Dec 2014 07:30:45 GMT

you can use the expression as dimensions before or after other dimensions

but even if you do so, the expression result will only appear after all the dimensions

so the only real option is to use calculated dimension , if you want to display the expression result as dimension

have a look at the attach example , the left most column is the expressions , you can move them around as you like

Re: Expression coulmn in pivot table before dimension

Mon, 01 Dec 2014 07:41:44 GMT

It will become a cross table structure, you can do this in a straight table chart though. In Straight Table chart, just hold and drag the expressions to front.