Discussion Board for collaboration on QlikView Scripting.
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.
(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)
Only straight table.... need to change the category...