Excel Table Import

[David_K]

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

[Rohan]

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.