Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Structure Data within excel file

Good day

I am struggling to structure the attached file within qlikview. I have been trying to create a cross table but with no luck.  Can someone please help?

4 Replies
Not applicable
Author

use pivot table for this. add dimension in below order

Customer, Market Sub Segment, year, month

then add all other expression. then try to drag year above all expr to create cross table then drag month under year. you will get your required crosstable.

ashfaq_haseeb

Hi,

Below document may help you regarding same.

multi_header_pivot_import.qvw

Regards

ASHFAQ

Anil_Babu_Samineni

Is's in Qlikview / Qlik sense

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

Qlikview