Write a daily count to a table

[bethany_]

Hi all

I am trying to write an app that will count the number of instances of "UI" in my column of outcomes.

The problem I have is the outcome column can be overwritten in the source system, and the system doesn't keep a copy of the previous outcomes. So to look back at the number of "UI" over time, I will need to write this information into a table somewhere for Qlik to read it to show the number are hopefully going down.

Is it possible to write to a table on load? So I could add the count to a table every day as it refreshes, like:

Date	Count UI
10/9/19	102
11/9/19	104
12/9/19	99

then tomorrow it would add another row, 

13/9/19

96

etc

Thanks in advance!

[dplr-rn]

Within qlik you can store it into a qvd. add new

e.g.

CountTable:

load Date , [Count UI]

from CountTable.qvd

concatenate

//new row code

store new CountTable into CountTable

similar concept as an insert only incremental load

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/