Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
reinholdgraf
Contributor

Re: Split of month-values into workingday-values

unknown error ---

we have 3 different Loads in one Section.

How is the order for the system to process these Loads ?

Re: Split of month-values into workingday-values

Not sure I understand your question, do you mind elaborating?

reinholdgraf
Contributor

Re: Split of month-values into workingday-values

top-down or bottom-up ?

I need to understand, how the systems processes your script-example to find the error.

(your script-example with inline-data works fine).

I first create a tmp_file containing all divisions with all plan-sales (monthly).

With this file (resident), I want to use your script to create daily-plansales and further calculations (e.g. currency-conversions, etc.)

MVP
MVP

Re: Split of month-values into workingday-values

You are using preceding loads in your script, these are executed bottom to top.

Preceding Load

What is the table source of your LOAD statement labelled with tmp_Umsatz_Plan?

Sunny was using an INLINE table, what table source do you intend to load? the Excel file?

Then remove the Concatenate LOAD prefix, it should be used only on the topmost LOAD statement.

If you need to use multiple files, create a concatenated table before, then use a resident table to use Sunny's script snippet.

reinholdgraf
Contributor

Re: Split of month-values into workingday-values

OK.

That's what I did.

1. Create a concatenated table (tmp_UMSATZ_PLAN1) from various excel-files

2. Use this table in the snippet

I removed now the "Concatenate", but with the same error-message when loading the data

How shall I find an "unknown error" ???

reinholdgraf
Contributor

Re: Split of month-values into workingday-values

Solved now !

problem was within the EXISTS-Formula.

Very helpful issues discussed here:

  • Snippet from Sunny and Exists-Formula
  • Info about Preceding Loads / Loading multiple files by Stefan

Many Thanks to both !