Comparing a field across dates - Identify any changes

Anonymous — Tue, 05 Jan 2016 16:00:23 GMT

Hello,

I am trying to perform 3 steps, which are as follows:

1.) Use an expression to list all items in a field that existed for date 1 and also for date 2. (If a record was present for one date but not the other, I want it excluded). Here is how I attempted this as a reference.

=avg({$<Date1={'41275'},[Primary SecID] = p({$<Date1={'42360'}>}[Primary SecID])>}[iRisk Average Life])

2.) Use an expression to list all items in a field that existed for date 2 and also for date 1. (If a record was present for one date but not the other, I want it excluded). Here is how I attempted this as a reference.

At this point, I would have one column with all my date 1 values and another with all date 2 values based on the primary key, which is [Primary SecID].

3.) I want to compare the results from step 1 and 2 below to identify any changes that occurred between the dates.

*The field I am comparing is [iRisk Average Life] and the dates are '41275' and '42360'.

Please let me know if this makes sense and if you are able to help. Thank you!

topic Comparing a field across dates - Identify any changes in QlikView

Comparing a field across dates - Identify any changes