Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Wow, just tried it, that's pretty cool. Much appreciated
H
can you please explain how it work ?
i have same problem and i am not able to get this.
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