Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
samith_sgh
Partner - Contributor II
Partner - Contributor II

How to load pivoted dimensions to Qlikview?

Hi all,

I have a pivot table in Excel to be loaded to Qlikview. I have already used CrossTable and reformated the table. And that's fine.

My problem is the dimensions. They are in a pivoted categorized form as follows.

Untitled.png

(Bold ones are main category and the next column is the sub category)

Is there a way to load them to table columns as follows? (Without using another categories matching up table)

REVENUEOther Legacy
REVENUE2010 NBS
REVENUE2011 NBS
REVENUE2012 NBS
REVENUE2013 NBS
REVENUEProvision for refunds
VARIABLE COSTSProvider Payments
VARIABLE COSTSAdministrative Fees
1 Reply
MK_QSL
MVP
MVP

Only straight table.... need to change the category...