topic Straight table, 'switch' axes in QlikView

Straight table, 'switch' axes

Michiel_QV_Fan — Thu, 16 Feb 2012 09:31:58 GMT

Hi,

I have a table like this:

Week	Revenue	Costs
1	100	90
2	110	95
3	90	96

But I would like to have this:

Keyfigure	1	2	3
Revenue	100	110	90
Costs	90	95	96

So it will be a straight table with the axes switched because I don't have the fields to create a pivot. All keyfigures are independend columns in my data and I want to keep it like that to make calculations (Revenue / Costs etc.).

How I can switch the axes?

Thanks for your help

Re: Straight table, 'switch' axes

jagan — Thu, 16 Feb 2012 09:35:30 GMT

Hi,

Use the pivot table for doing this

Please find the sample attached.

Regards,

Jagan.

Re: Straight table, 'switch' axes

jagan — Thu, 16 Feb 2012 09:38:26 GMT

Hi,

In the above attachment, I pivot the Rows into Columns and Columns to Rows.

Regards,

Jagan.

Straight table, 'switch' axes

Michiel_QV_Fan — Thu, 16 Feb 2012 09:41:04 GMT

That I didn't try. Great!

Re: Straight table, 'switch' axes

Anonymous — Mon, 08 Oct 2012 16:40:31 GMT

Jagan,

I was going through the app u attached, how were you able to do that, ..I mean what options to enable in the properties..

Thanks

Re: Straight table, 'switch' axes

jagan — Tue, 09 Oct 2012 15:49:42 GMT

Hi,

Use pivot table and try to drag the expression and dimensions horizontally/vertically as you required.

Regards,

Jagan.

Re: Straight table, 'switch' axes

Anonymous — Wed, 10 Oct 2012 15:54:59 GMT

Got it, thank you Jagan