topic Re: i need to load the excel data into qlikview in QlikView

i need to load the excel data into qlikview

nvijay5757 — Fri, 07 Oct 2022 18:57:06 GMT

i need to load this excel data into qlikview or qliksense.

after dashboard publishing this type of excel data only uploading how can i read this type of file.

the sample file attached.

Note: without changing the data in excel like pivot. basically backend data comes like this way. once upload the excel sheet without changing the data automatically read the dashboard.

please help me.

Re: i need to load the excel data into qlikview

anat — Thu, 06 Jan 2022 08:32:03 GMT

https://community.qlik.com/t5/QlikView-App-Dev/Import-pivot-table-from-Excel-into-Qlikview/m-p/710691

can u try above link if not tried....

Re: i need to load the excel data into qlikview

Frank_Hartmann — Thu, 06 Jan 2022 11:36:46 GMT

As a starting point see attached files.

I have derived the solution from here:

https://community.qlik.com/t5/QlikView-Documents/multi-header-pivot-import-qvw/ta-p/1487398/

hope this helps

Re: i need to load the excel data into qlikview

nvijay5757 — Sat, 08 Jan 2022 12:18:35 GMT

Hi,

i have tried this perfectly working. thanks

Re: i need to load the excel data into qlikview

nvijay5757 — Sat, 08 Jan 2022 12:20:47 GMT

Hi Frank, Thanks

your solution is working perfect. but i feel little bit complex as compare to above one.

Thanks a lot Frank.