topic Re: incremental load on hourly basis in QlikView

incremental load on hourly basis

Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

I need to get an hourly basis incremental record. I know hor to do an incremental load but the challange is i am unable to get make a table with an hourly count.

Time count

1Pm 200

2Pm 355

3Pm. 455

4Pm. 780.

I need to get the ablove data. Please help.

Re: incremental load on hourly basis

swuehl — Sun, 19 Mar 2017 08:56:52 GMT

I am not sure what you want to achieve here.

Looks like you want to accumulate a counter grouped by a Time value, but then you are talking about incremental load,which IMHO is a different concept for a different requirement.

I assume you want to do an incremental load of your facts (that seems to work?) and create additionally a table with an accumulated count of the records. A solution might be to also handle this count table similar to the facts.

Load in your historic count table, get the last count and add the count of records for the incremental facts. Append the count to the historic count.

Re: incremental load on hourly basis

Sun, 19 Mar 2017 10:59:07 GMT

Ok. If i dont want to do an incremental laod and display the hourly record's in a table on a single load then how do i achieve it.

Re: incremental load on hourly basis

swuehl — Sun, 19 Mar 2017 11:29:12 GMT

Something like

TMP:

LOAD Hour(YourTimestampField) as hour, Count(YourTimestampField) as count

RESIDENT YourFactTable

GROUP BY Hour(YourTimestampField);

RESULT:

LOAD hour, count, Rangesum(count, Peek(accumulated) ) as accumulated

RESIDENT TMP

ORDER BY hour;

DROP TABLE TMP;