How to load different tabs into single load statem... - Qlik Community

jsingh71 · ‎2013-05-08

Hi all,

I have one excel file and it’s contain four tabs. Is there any way where I can load all four different tab tables into a single load statement?

Please help me regarding this.

vikasmahajan · ‎2013-05-08

you need to select seperate sheets while loading multiple sheets in on qvw

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2013-05-08

Please refer screen short for the same

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

jsingh71 · ‎2013-05-08

Yes vikas that I know but I want to know is there any possibility to do the same using single load statement rather then select seprate sheets.

kumarnatarajan · ‎2013-05-08

Hi Amit 123,

Please find the below link, It is very help full for you

http://community.qlik.com/thread/54342

MK_QSL · ‎2013-05-08

This can be possible if all tabs are having same dimensions

Report Inappropriate Content · ‎2013-05-08

Amit,

This can be achieved by 'For each...'

please see http://community.qlik.com/message/15196#15196

How to load different tabs into single load statement??