Loading Excel dashboard data in Qlik

[Aspiring_Developer]

Hi ,

I have below data set available in Excel dashboard tabs :-

I want to upload this excel is qliksense and also clean the table using cross tab. How can I achieve this ?

I tried to upload the file in qliksene, but promopting me below error :-

This source file is hosted on sharepoint . Currently , I have downloaded it on my system and then trying to upload it in QS.

This is my actual data available in excel file :-

Actuals
Month	Apr-24	May-24	Jun-24	Jul-24	Aug-24	Sep-24	Oct-24	Nov-24	Dec-24	Jan-25	Feb-25	Mar-25
Total OR	49.21	51.20	48.29	49.75	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
OR Exchange	10.92	11.28	10.61	11.03
EV Charging	0.04	0.04	0.06	0.07
Exchange LLU Tenants	16.57	17.69	16.32	16.80
TEC	0.53	0.45	0.38	0.38
FTTC	21.17	21.74	20.91	21.48
FTTC and Exchange	32.08	33.02	31.53	32.51	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00

I wish to show the output in qliksense as below :-

Month	Type	Values
24-Apr	total OR	49.21

@Kushal_Chawda 

Thanks

[Aspiring_Developer]

Hi @Kushal_Chawda  Can anyone please help me on this one ?

Thanks

[madelonjansen]

Hi,

Can you upload (a sample of) the excel file?

[p_verkooijen]

Hi @Aspiring_Developer 

First you will have to check the file, if it is noted as corrupt you will never get it to work.

Use Crosstable to unpivot the dataset 

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/LoadData/work-with-cross-...

https://community.qlik.com/t5/Design/The-Crosstable-Load/ba-p/1468083

Can be quite hard to understand, an alternative could be to use QlikView desktop and use the wizard to configure the crosstable.

Qlik Sense should include the wizard options like QlikView had.... some handy features. Especially if you do not know of these options