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.