topic Loading Excel dashboard data in Qlik in App Development

Loading Excel dashboard data in Qlik

Aspiring_Developer — Mon, 02 Sep 2024 13:16:46 GMT

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 :-

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

Month	Type	Values
24-Apr	total OR	49.21

Thanks

Aspiring_Developer — Fri, 06 Sep 2024 07:36:00 GMT

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

Thanks

madelonjansen — Fri, 06 Sep 2024 08:27:12 GMT

Hi,

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

p_verkooijen — Fri, 06 Sep 2024 09:16:16 GMT

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

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