Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table row headers between expressions

I have a small chart where I'm comparing expressions year over year.  Currently I have the dimension as the year.  Then i have 3 expressions.  I have set the table to display horizontally, so that the dimensions are column headers and the expressions are rows.

What I want to do is show the Expression labels in between the 2 years being compared... so the prior year calculations appear on the left of the expression labels and the current year appears on the right.  I think i've seen this before but I can't find it again and I'm not even sure how to search for it.   So here's what I have:

20132014
Expression 16546516565874984
Expression 25469854868447488
Expression 35646584156468546

And here's what I'm trying to get:

20132014
65465165Expression 165874984
54698548Expression 268447488
56465841Expression 356468546

Can anyone help guide me?

Thanks

6 Replies
eduardo_sommer
Partner - Specialist
Partner - Specialist

Hi,

Just drag the expression column to the left of the dimension column

Eduardo

Not applicable
Author

I can't drag the columns, and i think it might be because i have the presentation set to horizontal?  The only thing i can move is the year dimension header up and down between the expression rows.

eduardo_sommer
Partner - Specialist
Partner - Specialist

Hi Ashley,

I think that with Horizontal selected you could not do what you want. Dragging can only be done between dimensions and expressions columns, If you use horizontal the dragging will be vertical.

Eduardo

Not applicable
Author

OK, do you have another suggestion to get to what i'm looking for?  I'm only using the horizontal orientation right now because it's the closest I could get to what I'm looking for.

crusader_
Partner - Specialist
Partner - Specialist

Hello Ashley,

How many columns do you have?

If only two, you can use vertical orientation with 2 expressions defined by different set analysis.

HTH

Andrei

eduardo_sommer
Partner - Specialist
Partner - Specialist

Unfortunately I have no suggestion for this.

Eduardo