Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

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
Author

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

H

Not applicable
Author

can you please explain how it work ?

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

simenkg
Specialist
Specialist

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