Discussion Board for collaboration related to QlikView App Development.
Hi guys, i am having a problem here. i have an excel sheet. i need to transform some rows into columns and the columns into rows. how to do it.
I have the format like this,
i want to load the Excel sheet like this
QlikViewApp DevelopmentCreating Analytics
CrossTable is your friend in this case
View solution in original post
when you import the excel file use the transformation step and use Cross table
u can simply load ur data first,
then use the pivot table and manually u can move rows as column or columns as rows on pivot table
else in ur edit script,u can use crosstable() for this see this thread
Manipulating Data / Cross Table
You can use the crosstable function to transform the data.
CrossTable(Type, Value, 3)
[Admin & Support]
Then create a pivot table object with Facility, Date, Type and Categories as dimensions. Drag the Categories dimension to the right above the expressions to pivot it to horizontal layout.