Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
gregoryt40
New Contributor

Comparing a field across dates - Identify any changes

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!

Community Browser