Hello there,
I have been trying to tame the Buffer statement for quite the while now and, either there is something I am missing or there is something not working quite as it should.
I will be using the case I am working with as an example to help illustrate my explanation:
I want to measure the scalability of my data loading script depending on the maximum data loaded per data origin.
For this purpose I make use of 3 variables:
[Start of the script]
Let vStart = Now();
Set vScaleStep = 100;
(...)
[data loading script]
(...)
[end of the script]
Let vEnd = Now();
Let vReloadTime = TIME(vEnd-vStart,'hh:mm:ss');
And use them as follows:
[Performance]:
Load
LoadDate,
NumRegisters,
ReloadTime
Inline [
LoadDate,NumRegisters,ReloadTime
$(vStart),$(vScaleStep),$(vReloadTime)
];
Thus storing the values in a table.
Now, I would like this table, Performance, to be increasingly larger with each reload, so I thought of making use of this Buffer (Incremental) thingy. The following script is my attempt:
[temp]:
Load
LoadDate,
NumRegisters,
ReloadTime
Inline [
LoadDate,NumRegisters,ReloadTime
$(vStart),$(vScaleStep),$(vReloadTime)
];
[Performance]:
Buffer (Incremental)
Load
LoadDate as Performance.LoadDate,
NumRegisters as Performance.NumRegisters,
ReloadTime as Performance.ReloadTime
Resident temp;
Drop Table temp;
I do it in two steps (using a temporary table with Resident) because, if the load statement used temp's inline expression, the load expression would be different every time and the qvd bufer would be replaced and never really used.
Now, what I am getting from this attempt of mine is a 1 line Performance table that never changes its content: the qvd buffer is not being appended new information with each reload, as I wished it to.
Why is the Qlik Sense not recognizing the new information coming from the resident table and just loading the buffer?
I was perfectly able to create a workaround, but I am annoyed by not being able to make this work as I wanted it to, having to resort to manually managing qvd files and resident loads...
