Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

michielvandegoo
Valued Contributor

Straight table, 'switch' axes

Hi,

I have a table like this:

WeekRevenueCosts
110090
211095
39096

But I would like to have this:

Keyfigure123
Revenue10011090
Costs909596

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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Straight table, 'switch' axes

Hi,

Use the pivot table for doing this

Please find the sample attached.

Regards,

Jagan.

6 Replies
MVP
MVP

Re: Straight table, 'switch' axes

Hi,

Use the pivot table for doing this

Please find the sample attached.

Regards,

Jagan.

MVP
MVP

Re: Straight table, 'switch' axes

Hi,

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

Regards,

Jagan.

michielvandegoo
Valued Contributor

Straight table, 'switch' axes

That I didn't try. Great!

balrajprabhu
Contributor

Re: Straight table, 'switch' axes

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

B

MVP
MVP

Re: Straight table, 'switch' axes

Hi,

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

Regards,

Jagan.

balrajprabhu
Contributor

Re: Straight table, 'switch' axes

Got it, thank you Jagan

Community Browser