Can any one tell me how can i load a excel file with multiple sheets in qlik view
waiting to your reply
After clicking on Table Files > choose your excel from browse and then File Wizard window Click on drop down Tables. Here you will see the list of sheets available in your excel.
that i knew i want to load all sheet in one reload how can i do that ?
There is no other option available in Qlikview then. I don't know may be Macro might work out in your scenario.
But at once you cannot load all sheets in Qlikview.
Suggestion: If possible and if suits your environment then please treat each sheet as a excel.
But there is way to load all sheets data that i know anyways thanks a lot
Please see this discussion
Retrieving data ...