14 Replies Latest reply: Oct 14, 2016 11:44 AM by Jim Chan RSS

    Set Analysis to display new record in a text box object

    Jim Chan

      HI guys,

       

      I am following this post regarding how to use set analysis for new record. I was following 1 of the sample:

      How to check if Record exist in Previous Month ? | Qlik Community

       

      in the straight table expression, it is written as:

       

      IF(COUNT({<batch_year = {'<$(=Max(batch_year))'}, risk_item_id = P({<risk_item_id>})>}risk_item_id)>0,'NO','YES')

       

      I wonder how can i change or convert this line of code to show me amount of new records in text box object.

       

      Rgds,

       

      Jim