Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day, dear colleagues!
QlikView version 12.0.20000.0, Excel 2016.
When loading of Excel file QlikView can not see the dates with 01.10.2016. Dates until 01.09.2016 loading properly. What could be the problem?
Yours faithfully
Andrey Khor
Sergey, thank you for the detailed answer.
No witchcraft, as usual, there is no. The error was in the code. Since I raised the topic, I will describe the order.
This script code
After downloading the file represented by the above it got this data structure
Forming dashboard
The amount of red color field "Sum (SumComing)". Please note there is no current selections.
But in the original amount of the other Excel file (the difference is highlighted in red below)!
If on the sheet "Consumption" to add an entry with the date 01/10/2016, on dashboard everything is correct.
The error is contained in a line of code that defines the left join - not available the connection table.
If the first table "Consumption" in this embodiment, the default code associated with the table "MasterCalendar", the second table "Coming" associated with the first "Consumption". Therefore, the availability of the dates in the first table "Consumption" in the left-hand connection and is decisive for the date of the second table "Coming".
Correct line of code 56 is replaced by the following
Now everything is working properly.
Once again thank you all for your answers.
All the best
Would you be able to share your sample Excel file? I can try test loading it into a new QVW to check what is going on. I have QlikView 12.0.
If there is no record with the date 10/01/2016 on the sheet "Consumption" file Excel, record with the date 10/01/2016 from sheet "Coming" to QlikView not unloaded (red).
I have not see any problem with loading data from your file.
QV Application (v.12) example you can see in attach.
I suppose you trying to load data from "Consumption" Tab (not from "Coming" Tab). And of course you will not see the 10/01/2016 date after this Load, because this date does not exists on the "Consumption" Tab.
Thanks for the answer. What caused this logic works QlikView? Why can not I use the sheet 2, without filling Sheet1?
I think there are some misunderstanding and/or mixing different aspects in Data Loading logic. So my answer will have more detail:
Sergey, thank you for the detailed answer.
No witchcraft, as usual, there is no. The error was in the code. Since I raised the topic, I will describe the order.
This script code
After downloading the file represented by the above it got this data structure
Forming dashboard
The amount of red color field "Sum (SumComing)". Please note there is no current selections.
But in the original amount of the other Excel file (the difference is highlighted in red below)!
If on the sheet "Consumption" to add an entry with the date 01/10/2016, on dashboard everything is correct.
The error is contained in a line of code that defines the left join - not available the connection table.
If the first table "Consumption" in this embodiment, the default code associated with the table "MasterCalendar", the second table "Coming" associated with the first "Consumption". Therefore, the availability of the dates in the first table "Consumption" in the left-hand connection and is decisive for the date of the second table "Coming".
Correct line of code 56 is replaced by the following
Now everything is working properly.
Once again thank you all for your answers.
All the best