topic Re: How to unzip a file in QlikView

How to unzip a file

naveen341 — Tue, 17 Nov 2015 18:59:16 GMT

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

Re: How to unzip a file

Clever_Anjos — Tue, 17 Nov 2015 20:17:39 GMT

Would you mind posting a screenshot?

QlikCommunity Tip: How to get answers to your post?

Re: How to unzip a file

naveen341 — Tue, 17 Nov 2015 20:20:55 GMT

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

Re: How to unzip a file

sinanozdemir — Tue, 17 Nov 2015 21:15:07 GMT

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.