topic Change table orientation in QlikView

Change table orientation

Thu, 15 Jul 2010 16:11:27 GMT

Hello people,

I have a table object that is something like this:

Enrolled Students | Evaluated Students | Non - Evaluated Students | ........

120 | 100 | 20 | .......

50 | 25 | 25 |..........

I would like to know if there is anyway I can change the orientation of the table to obtain something like:

Enrolled Students | 120 | 50

Evaluated Students | 100 | 25

Non - Evaluated Students | 20 | 25

Thu, 15 Jul 2010 16:40:19 GMT

Use pivot table type chart. You can drag and drop dimensions from Y-axis to X-axis and vice versa.

Thu, 15 Jul 2010 16:42:29 GMT

You can't do that with table object but you can try whith a straight table.

"Enrolled Students ", "Evaluated Students" and "Non - Evaluated Students " as Dimension and "=1" for exemple as expression

In "properties->Presentation" :

- On the area on the top/left, select the line "=1" and check "hide column"

- On the area above, check 'boxes : "Horizontal"

you should have what you want.

Regards

Benoît

Thu, 15 Jul 2010 17:11:10 GMT

Perfect 🙂 Thank you both!