Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ramyasaiqv
Contributor II

Loding Multiple cross tables from Muultiple Sheets of Excel

Hello Community,

I’m trying to load multiple cross tables (Same fields just different years data) from multiple sheets of an excel and had no success. I did lot of research in the forum still I’m not able to resolve my issue. So I’m here for help please help me.

Attached script is working if I load year by year but I want to load all the sheets at a time as I want to make it dynamic.

I have attached the qvw I was working and also attached the sample excel with 2 sheets (2016 and 2017) data. Please help in trouble shooting the issue or please suggest if there a better way of doing it. Thank you,

Ramya

1 Solution

Accepted Solutions
ramyasaiqv
Contributor II

Re: Loding Multiple cross tables from Muultiple Sheets of Excel

Daniele,

I tried and it didn't work for my requirement. i figured out another way to solve my issue.Thank you,

Ramya

3 Replies
ramyasaiqv
Contributor II

Re: Loding Multiple cross tables from Muultiple Sheets of Excel

Any help or suggestions please?

Thank you,

Ramya

danistontt
New Contributor

Re: Loding Multiple cross tables from Muultiple Sheets of Excel

Hi Ramya,

have you tried this?

Load Multiple excel sheets using For loop

Daniele

ramyasaiqv
Contributor II

Re: Loding Multiple cross tables from Muultiple Sheets of Excel

Daniele,

I tried and it didn't work for my requirement. i figured out another way to solve my issue.Thank you,

Ramya