topic Re: Table row headers between expressions in QlikView

Table row headers between expressions

Tue, 24 Jun 2014 17:53:21 GMT

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:

	2013	2014
Expression 1	65465165	65874984
Expression 2	54698548	68447488
Expression 3	56465841	56468546

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

2013		2014
65465165	Expression 1	65874984
54698548	Expression 2	68447488
56465841	Expression 3	56468546

Can anyone help guide me?

Thanks

Re: Table row headers between expressions

eduardo_sommer — Tue, 24 Jun 2014 18:02:59 GMT

Hi,

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

Eduardo

Re: Table row headers between expressions

Tue, 24 Jun 2014 18:10:52 GMT

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.

Re: Table row headers between expressions

eduardo_sommer — Tue, 24 Jun 2014 18:35:03 GMT

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

Re: Table row headers between expressions

Tue, 24 Jun 2014 18:41:26 GMT

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.

Re: Table row headers between expressions

crusader_ — Tue, 24 Jun 2014 19:08:08 GMT

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

Re: Table row headers between expressions

eduardo_sommer — Tue, 24 Jun 2014 19:08:16 GMT

Unfortunately I have no suggestion for this.

Eduardo