Write a daily count to a table

bethany_ — Thu, 12 Sep 2019 14:08:44 GMT

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

etc

Thanks in advance!

Re: Write a daily count to a table

dplr-rn — Thu, 12 Sep 2019 14:54:26 GMT

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/

topic Write a daily count to a table in App Development

Write a daily count to a table

Re: Write a daily count to a table