3 Replies Latest reply: Nov 5, 2012 10:37 AM by gerrywhite RSS

    Table size changes every day

      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!