Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a table like this:
But I would like to have this:
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
Go to Solution.
Use the pivot table for doing this
Please find the sample attached.
In the above attachment, I pivot the Rows into Columns and Columns to Rows.
That I didn't try. Great!
I was going through the app u attached, how were you able to do that, ..I mean what options to enable in the properties..
Use pivot table and try to drag the expression and dimensions horizontally/vertically as you required.
Got it, thank you Jagan