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.