10 Replies Latest reply: Oct 4, 2016 12:22 PM by Marcus Sommer RSS

    data reduction in qlikview when automatic reloads

    jojee Jojee M Issac

      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
      [D:\QlikView Live\Data\Permission.xlsx]
      (
      ooxml, embedded labels, table is [P&W]);

      Section Application;

       

       

      Please let me know what could be the reason.