Discussion Board for collaboration related to QlikView App Development.
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
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.
View solution in original post
Use pivot table type chart. You can drag and drop dimensions from Y-axis to X-axis and vice versa.
Perfect 🙂 Thank you both!