Skip to main content
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
Champion III
Champion III

Hi,

Below document may help you regarding same.

multi_header_pivot_import.qvw

Regards

ASHFAQ

Anil_Babu_Samineni

Is's in Qlikview / Qlik sense

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

Qlikview