Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
oxiofrt
Partner - Creator
Partner - Creator

Rotating a simple table

Hi,
I have a table which look like this :

User | Organisation
FRT | Org_1
SCA | Org_2

I would like to rotate it so as it would look like :
User | FRT | SCA
Organisation | Org_1 | Org_2

Is it possible to do it ? And how ?

Thanks a lot for your help!

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

Properties -> Presentation -> Horizontal

Or am I not understanding the question?

View solution in original post

3 Replies
johnw
Champion III
Champion III

Properties -> Presentation -> Horizontal

Or am I not understanding the question?

oxiofrt
Partner - Creator
Partner - Creator
Author

Well, you have well understood the question but the property you are explaining is only available in chart but not in table box.

For the moment i use to make charts as this functionality doesn't seem to be available for table boxes. Do you confirm ?

Thanks a lot for your help 🙂

johnw
Champion III
Champion III

Ah, oops! Sorry for misreading. Well then my advice is to use a straight table instead of a table box. I think I've also heard rumor that straight tables are more efficient than table boxes, though I've never tested it, and it frankly wouldn't make any sense to me. Anyway, just add all your dimensions to a straight table, use a "fake" expression, such as the value 1, then hide that column on the presentation tab. Then you have something that looks just like a straight table, but has all the power and formatting control of a chart.