Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mail2bsk
Contributor
Contributor
‎2018-02-14 03:49 PM

Load Multiple Header data in qlik

Any idea how can attached file can be loaded into qlikview as below format.

Country,

Manager,

Product Type,

Months,

Amount

               

Product AProduct B
CountryManagerTotalMayJunJulAugSepOctNovDecJanFebMarAprTotalMayJunJulAugSepOctNovDecJanFebMarApr
AmericasManager 110212 11 11 1 10212 11 11 1
AmericasManager 210212 11 11 1 10212 11 11 1
AmericasManager 32422222222222224222222222222
AmericasManager 4222 2222222222222 2222222222
AmericasManager 52422222222222224222222222222
AmericasManager 62422222222222224222222222222
AmericasManager 7222 2222222222222 2222222222
Preview file
14 KB
319 Views
0 Likes
1 Reply
settu_periasamy
Master III
Master III
‎2018-02-14 04:04 PM

Maybe look this multi_header_pivot_import.qvw

254 Views
0 Likes