Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
paulyeo11
Valued Contributor II

Why after load big file into QS , the file size become big ?

Hi All


My issue is when the file size getting bigger and I am not able to load up cloud. As cloud upload have file size control, This happen on QS ver 3.


Step 1 :- Load small file

My Qlik Sense after load , SMALL FILE SIZE 6 M below :-

https://www.dropbox.com/s/adtq4sxsj8v7wd8/6M.qvw?dl=0

Above link is my QVW file.

Binary 'lib://v/6M.qvw';

My QVF file size = 7.1 M

Step 2 :- Load big file

If I try to load , BIG FILE SIZE 12 M

https://www.dropbox.com/s/a73f6fr62rcezpp/12M.qvw?dl=0

Above link is my QVW file.

Binary 'lib://v/12M.qvw'; 

My QVF file size = 20 M

Step 1 :-Load small file

My Qlik Sense after load , SMALL FILE SIZE 6 M below :-

https://www.dropbox.com/s/adtq4sxsj8v7wd8/6M.qvw?dl=0

Above link is my QVW file.

Binary 'lib://v/6M.qvw';

My QVF file size = 17.9 M

My question is how to make it 7.1 M ? at step 3.

Paul

1 Solution

Accepted Solutions
robert99
Valued Contributor II

Re: Why after load big file into QS , the file size become big ?

Hi

I had an issue where the file size was increasing markedly for no reason. From under 50,000KB to 125,000+ and increasing even change I made.

What I eventually did was reload just the first sheet (set statements) using exit script. and then reload everything again. It dropped back down to 45,000 KB.

It is unlikely to help you though

6 Replies
robert99
Valued Contributor II

Re: Why after load big file into QS , the file size become big ?

Hi

I had an issue where the file size was increasing markedly for no reason. From under 50,000KB to 125,000+ and increasing even change I made.

What I eventually did was reload just the first sheet (set statements) using exit script. and then reload everything again. It dropped back down to 45,000 KB.

It is unlikely to help you though

paulyeo11
Valued Contributor II

Re: Why after load big file into QS , the file size become big ?

‌Hi Robert

THamk you very much for your reply.

Mmay I know what you mean you load only first sheet ? Can you give me more detail info pls..

BY the way , in your opening , you mention that you also encounter the same same issue like I face. So you are one of the Qlik sense user right ?

Paul

paulyeo11
Valued Contributor II

Re: Why after load big file into QS , the file size become big ?

Hi Robert

I just try your approach , and it work fine now.

Paul

Not applicable

Re: Why after load big file into QS , the file size become big ?

Robert, hello

I have been following your post. I am unable to send you a private message. Can you accept my connection, so we can message. I like to ask you for the BI comparison guide you created for Qlik-PowerBi-Tableu.

Regards, talk later.

paulyeo11
Valued Contributor II

Re: Why after load big file into QS , the file size become big ?

Hi Robert

May you share the Tableau info with , I have try it about 2 year ago , they don't have personal edition , so with in 15 days i am not able to figure and the forum is not as active as Qlik forum.

Paul Yeo

Director

www.tdstech.com<http://www.tdstech.com>

HP+6285883521036 Indo

robert99
Valued Contributor II

Re: Why after load big file into QS , the file size become big ?

Hi Paul

More than happy to. I have recently updated for the latest sense 3.1 and the Power BI September 16 updates

But you need to send me a private message with you email address to send it to

Cheers Robert