topic Load Pivot table in QlikView

Load Pivot table

amit_saini — Mon, 18 Jun 2018 11:09:40 GMT

Hi Folks,

Can you please suggest how to handle attached Pivot table data in QlikView.

I know cross table function, I can load the whole data in different parts , but is there any simpler way???

Please advice!

Regards,

Re: Load Pivot table

Frank_Hartmann — Mon, 18 Jun 2018 11:26:40 GMT

this might be helpful:

multi_header_pivot_import.qvw

Re: Load Pivot table

sunny_talwar — Mon, 18 Jun 2018 11:28:18 GMT

Have you tried this?

multi_header_pivot_import.qvw

Re: Load Pivot table

avkeep01 — Mon, 18 Jun 2018 11:34:29 GMT

Hi Amit,

I've created an example for you. The only thing is that I hardcoded the "revenue" and "volumes" column, so if you add another type you'll need to update the script.