topic Re: Size dropped after distribution in QlikView

Size dropped after distribution

krishnacbe — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I have distributed am application from Source document to User Documents. Actual size of the document is 2 GB in source document, but after distribution dashboard size got dropped to 600 MB.

Please let me know what could be the reason for this.

Regards

Krishnapriya.

Re: Size dropped after distribution

magavi_framsteg — Tue, 15 Apr 2014 11:46:18 GMT

Maybe the publisher reduced the document?

- QMC > Reduced tab in the document task

Or maybe the data sources differ from before reload to after reload?

If you manually reload the document from the source folder, it should be the same size (give or take) as to when the very same document is published.

Re: Size dropped after distribution

Bill_Britt — Tue, 15 Apr 2014 11:57:06 GMT

Hi,

Your issue is you have section access applied to the document and the service account doesn't have rights to see all the data. So, it loads what it has access to.

Bill

Re: Size dropped after distribution

krishnacbe — Tue, 15 Apr 2014 12:35:15 GMT

Hi Bill,

Thanks for your input.

I have provided full Privilege (*) to service account.

Manual Load of source document has 2 GB size, after distribution it is 600 MB.

Regards

Krishnapriya.

Re: Size dropped after distribution

Bill_Britt — Tue, 15 Apr 2014 12:40:17 GMT

Hi,

I still think there is an issue with the service account having rights to all data. Three things you can try.

1. Change service account for the distribution service to your login account and see what happens.

2. in the task on the reload tab, add your account for the Data Protection information.

3. login into machine with the service account ID and run it and see what happens.

Bill

Re: Size dropped after distribution

krishnacbe — Tue, 15 Apr 2014 12:48:10 GMT

Hi,

Sure, will try the option.

Thanks a lot.

Regards

Krishnapriya

Re: Size dropped after distribution

krishnacbe — Tue, 15 Apr 2014 13:50:00 GMT

Hi Bill,

I have tried all the three options, but no luck. Still Data got reduced.

Regards

Krishnapriya.

Re: Size dropped after distribution

Colin-Albert — Tue, 15 Apr 2014 13:55:08 GMT

Does your section access script have some reduction fields that use *, but you do not have all possible values listed against the other users.

* in section access refers to All Listed Values not All Values That Exist in the data!

Re: Size dropped after distribution

krishnacbe — Tue, 15 Apr 2014 13:58:33 GMT

Hi Colin,

Thanks for your response.

Yes you are right I have used * for reduction fields for admin.

Can you please explain how to define All Listed Values not All Values.

Regards

Krishnapriya.

Re: Size dropped after distribution

Bill_Britt — Tue, 15 Apr 2014 13:59:37 GMT

The only thing I can think of is to REM out section access and see what happens.

Bill

Re: Size dropped after distribution

Bill_Britt — Tue, 15 Apr 2014 14:00:09 GMT

Do you have the * for the service account?

Re: Size dropped after distribution

gainkarthi — Tue, 15 Apr 2014 14:01:26 GMT

Remove * and keep nothing for Admin account (ie Empty value for filter).

* gives you consolidation of other user filters and empty is actually giving you full data.

Re: Size dropped after distribution

Colin-Albert — Tue, 15 Apr 2014 14:03:03 GMT

Leave the reduction field empty to include all values.

Re: Size dropped after distribution

krishnacbe — Tue, 15 Apr 2014 14:10:22 GMT

Hi Karthik/Bill/Colin,

I have tried both * and null value for Admins/Service account. but no luck.

Sure Bill I will try removing section access and distribute the app.

Regards

Krishnapriya.

Re: Size dropped after distribution

magavi_framsteg — Wed, 16 Apr 2014 10:42:22 GMT

Or you can still use SA, but with "Initial selection" instead of "Initial reduction" set in the tab Document Properties > Open.

Then you can see what the reduction would be, but as a selection instead of reduction.