Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Make expression columns into rows

Hi all,

By default in Qlikview say in a straight table or pivot table, when you have an expression, the results are displayed in a column. How can I change this so that my results are displayed horizontally.

I have tried a pivot table, but with a pivot table its the dimensions that I can "pivot" and not the expressions?

Any help appreciated.

Thank you

H

4 Replies

Re: Make expression columns into rows

You can pivot the expressions as well in a pivot table. Just keep in mind that all expressions are displayed the same way, either all as rows or all as columns. Simply drag an expression header to the left side of the pivot table.


talk is cheap, supply exceeds demand
Not applicable

Re: Make expression columns into rows

Wow, just tried it, that's pretty cool. Much appreciated

H

Not applicable

Re: Make expression columns into rows

can you please explain how it work ?

i have same problem and i am not able to get this.

bwisenosimenkg
Valued Contributor

Re: Make expression columns into rows

For pivot-tables you can just drag the dimensions.

For Straight tables you have to go into the "Presentation-tab" and check the "Horizontal"-box. This will display the dimensions as columns and the expressions as columns

Community Browser