Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
Can any one tell me how can i load a excel file with multiple sheets in qlik view
waiting to your reply
Hello,
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.
Thanks,
Advait
that i knew i want to load all sheet in one reload how can i do that ?
Hello,
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.
Thanks,
Advait
Thanks Advait
But there is way to load all sheets data that i know anyways thanks a lot