Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

data reduction in qlikview when automatic reloads

We have an issue facing in data when automatic reloads with the distribution service.

The data is not loading fully when  automatic reloads runs at morning using the service account(distribution service).

But when reload manually with the same service account , the data is loading perfectly.

The Initial Data Reduction Based on Section Access & Strict Exclusion are checked. We have section access defined as below  .

   

ADMINQLIKVIEW ADMIN1BENZ\qadmin1ALLALL
ADMINQLIKVIEW ADMIN1qadmin1ALLALL

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 what could be the reason.

10 Replies
marcus_sommer

Section access meant either on or off - a skipping to a condition isn't possible. But maybe by using the publisher you could use loop and reduce: Reduce and loop by NT username.mp4

- Marcus