Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
David_K
Contributor III
Contributor III

Excel Table Import

Hello fellow Qlik Sense users,

I have a traditional table in Excel, with customer data in the first 3 columns (A-C) , followed by the the sales value by month in the following columns (D onwards)

Is there a way I can load this into Qlik Sense, and use the data to report on when linked with additional customer information in the app.

Many thanks in advance

David

1 Reply
Rohan
Specialist
Specialist

Hi David,

For importing excel file into Qlik Sesne, Refer the following link :

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/DataSource/load-data...

& if you wish to transpose your MoM values columns into  Month & sales Column, you can use the CrossTable function in Qlik Load script, Refer below link :

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...

Regards,

Rohan.