2 Replies Latest reply: Feb 3, 2017 2:17 PM by Sunny Talwar RSS

    How to find New Record by writing a set analysis/front end script

    Jim Chan

      Hi guys,

       

      I have created a sample.qvw file as per attached.

       

      in this example my records data for year 2015 and 2016 is loaded into 1 table.

       

      There are few scenario i wanted to achieve. But i am not getting it from this expression:

       

      Count(DISTINCT {<record_id = e({<record_id = {"=Count({<year = {'<$(=Max(year))'}>} record_id) > 0"}>})>} record_id)


      By using the above expression for the New Risk - it gives me 3 new risks from 2015-2016. But that's not what i need now. 

      If the user select year 2016, 2nd Half, version 4 - it should display 1 Risk only, when it compares to year 2016 1st half version 3

      If the user select year 2016, 1st half, version 3 - it should display 2 Risks only, when it compares to year 2015 2nd half version 2

       

      Those expected result i have already written in qvw file.

       

      - Expected result for NEW RISK.

      If i click on year 2016 2nd Half version:4

      New Risk found = 1, record id = 98071 compare to 2016 1st half version 3


      - Expected result for DELETED RISK.

      If i click on year 2016 2nd Half version:4

      Deleted Risk = 2 , record id: 56748 & 98596

       

      Please help guys

       

      Rgds

       

      Jim