topic Table size changes every day in QlikView

Table size changes every day

Mon, 05 Nov 2012 13:37:47 GMT

Hi All

I am about to begin the visualisation of a dataset. Its basically 1 table which currently has about 1000 entries. Over time, these entries will be reviewed and will be tagged as RELEVENT or NOT RELEVENT (or whatever). I want to visualise this happening over time (so I can see review speed, fast vs slow reviewers etc). However, the dataset will also grow over time, with new entried being added on a weekly basis, so count(UniqueID) will be less useful.

Aside from generating a table of metadata on the SQL Server side of things oin a daily basis (where it performs counts of total records/releven records etc), is there a way QlikView can manage this? Perhaps storing or timestamping data as its loaded? Just after some initial thoughts at this state.

Thanks!

Re: Table size changes every day

Mon, 05 Nov 2012 15:13:40 GMT

If I understood what you need, I think you can put that timestamp in your SQL Server DB with a field like 'Entry_Date' which will have the time of the entry as default. Then, as every record that had been added will have the time of the entry, in QV you can manage that with Set analysis.

Hope it helps.

TMF

Re: Table size changes every day

Mon, 05 Nov 2012 15:37:04 GMT

I think you're right, this is the easiest solution.

Re: Table size changes every day

Mon, 05 Nov 2012 15:37:08 GMT

I think you're right, this is the easiest solution.