How to unzip a file

[naveen341]

hello,

the data i am receiving from the source is in the excel format if the size of the excel is more than 250kb its getting in the zipformat how can i unzip it and use it in a qlikview to build dashboards

[Clever_Anjos]

Would you mind posting a screenshot?

QlikCommunity Tip: How to get answers to your post?

[naveen341]

c the source data i am receiving is in zipformat so how can i unzip them and feed it to qlikview?

which screen shot u needed

[sinanozdemir]

Hope the attached helps:

I am attaching two files one is a zip folder that has an excel sheet called "Example.xlsx" and the second one is the qvw file that has a macro to unzip and load the first sheet:

First, save the zipped folder on your desktop and change the path to this zipped folder in the load script:

       

And then reload the document. You can also see the macro by pressing both Ctrl + M.

Hope this helps.