Adding current data to historical data

tinkerz1 — Tue, 29 Sep 2015 13:04:43 GMT

Hi,

In this qlikview document I am trying to simulate what I am trying to do in a larger QVD.

I have 3 Tables:

History, which is all the data apart from the current month

New Months Data: that is all the data from the current month not in history

Threshold: these are levels that can be uploaded by the end user to check if the months activities are good or bad.

In the script I join the hostory to the Threshold by adding a date to expand the dimension.

THe problem is using set analysis on the [New Months Data]

it must fit onto the new month and in the data field cell, so a cross reference of 2 fields.

My issue is I will have many sets to do, not just 'data', I dont know how to adapt the set analysis in DATA>01/01/2015

to work on the new month.

Help please.

I dont need to adapt the [New month data] loads to match the history, the new data will de defined by set analysis on the new data.

It seems I cant create cell to put the data in.

topic Adding current data to historical data in QlikView