Data reduction when automatic reloads

Wed, 25 Nov 2020 16:16:04 GMT

We are getting an issue with the automatic load with the distribution service.

Data is not fully loaded when the automatic reloads run but when we reload manually with the same service account , the entire data loads perfectly.

The service account has added in the section access shown below with the group and branch as "ALL" ,

Initial Data Reduction Based on Section Access checked

Strict Exclusion Checked

ADMIN	QLIKVIEW ADMIN1	BENZ\qadmin1	ALL	ALL
ADMIN	QLIKVIEW ADMIN1	qadmin1	ALL	ALL

Section Access;

LOAD ACCESS,
NAME,
NTNAME,
IF(GROUP='ALL','*', GROUP) as 'Stock Group', // STOCK
   IF(GROUP='ALL','*', GROUP) as Group, // PARTS SALE
   IF(GROUP='ALL','*', GROUP) as GROUP., // LABOUR LOG
   IF(GROUP='ALL','*', GROUP) as GROUP.., //CLOCK ENTRIE
   IF(BRANCH='ALL','*', BRANCH) as Branch,
IF(BRANCH='ALL','*', BRANCH) as 'Branch Name', // W.Revenue Branch
   IF(BRANCH='ALL','*', BRANCH) as Branch.Name // W.Analysis Branch

FROM

(ooxml, embedded labels, table is [P&W]);

Section Application;

Please let me know if any other settings has been missed as we are using the qlikview 11

Re: Data reduction when automatic reloads

rupamjyotidas — Thu, 29 Sep 2016 18:23:05 GMT

Maybe all you fields needs to be in UpperCase.

Re: Data reduction when automatic reloads

Mon, 03 Oct 2016 06:13:15 GMT

All fields are in upper case

topic Re: Data reduction when automatic reloads in QlikView

Data reduction when automatic reloads

Re: Data reduction when automatic reloads

Re: Data reduction when automatic reloads