1 Reply Latest reply: Aug 21, 2013 3:14 AM by Anatoly Pyatygo RSS

    concatenate statement, lost data question

      Dear QlikView Community,

       

      I load several Excel-Tables into my QlikView document. The loaded data for internal budgets gets lost every time I close my file. I have used the concatenate statement with CrossTableFinal. The problem is the same if I load the table without concatenate the statement. What I do:

      1. Open the file saved on the server

      pic1.png

      2. Run the load script ==> All data is up-to-date

      pic2.png

      3. Save the file on the server

      4. Close the file

      5. Re-open the file (from server or QlikView Access Point) ==> Layout changes, script changes, and all data except for one table (see load script above for missing data) are up-to-date.

       

      I am using a section access on this document with strict data reduction on opening (NTNAME and NTNAME2). I can see all restricted data after reload, only the one table is lost after saving… However I do not have the problem if I deactivate the data reduction. I can see all entries for “Account” and “Order_Description” so I cannot understand why I cannot see the data for “BudgetData”

       

      Do you have any idea who to solve this problem?

       

      Thank you!