Just a few weeks with Qlikview and still need lots of help from the experts in this forum.
I have millions of records which consist of time stamp and values (data volume). I'd like to build a chart showing two lines; upper bound limits and lower bound limit based on this historical records. It will be somewhat a statistical type of chart that will be used as a reference, so the output will be a chart with two lines; one showing lower bound limit and another line showing upper bound limit, with certain probability or confidence factor (e.g. 95%). These two reference lines are based on historical data collected.
Once the reference chart above is done I will then need to load new records and compare them (overlay the new data in the same chart) and display these new records and show in the same charts if these new records are below or above the statistical upper and lower limits lines.
Any help would be appreciated.
