load month wise data

[swatitomar]

hii,

I have month wise data in excel ...plz suggest me some good way to load the data..

[thomas_skariah]

Hi Swati,

Can you share the screenshot of the data (columns) inside the sheets.

Regards,

Tom

[tresesco]

hope those are your sheets, please have a look at:

http://community.qlik.com/message/165200#165200

http://community.qlik.com/message/229163#229163

Thanks.

[swatitomar]

Screenshot of data(columns) inside the sheet.

[#5]

use *.xls in load statement, tht will pull all the data from every sheet

[er_mohit]

Use Crosstable function

in help learn about it and its working

Hope it helps

Regards

Mohit

[#7]

If these multiple sheets will grow dynamicall means..

I will recommend below link

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