I need to create a new column. In which I need to put the numbers by condition

[Dmitryromanov23]

Good afternoon, everyone. I'm looking for a solution to this problem: I need to create a new column. In which I need to put 1. But! If this ID has "justified_warning" and "justified_repetition" statuses, then "justified_repetition" status should have 0 in the new column. How can I do this in qlik?

Like this

[rubenmarin · Accepted solution]

Hi, you can crete a temporary field to store ids that has loeaded a justified_warning, so when a justified_repetition is loaded you can check this field values. like:

LOAD
  id,
  status,
  If(status='justified_warning', id) as checkId,
  If(status='justified_repetition' and Exist('checkId',id)
    ,0 , 1) as new_column
From/resident...;

DROP Field checkId;