Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
samith_sgh
New 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
Tags (2)
1 Reply
MVP
MVP

Re: How to load pivoted dimensions to Qlikview?

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

Community Browser