11 Replies Latest reply: Sep 28, 2018 5:35 AM by Tim Poismans RSS

    Conditional Check on a One-Many Relationship

    Manikantan S

      Hi All,


      I have 2 tables with One - Many Relation ship.


      Table 1 - Contains ProjectID, one row per Project ID

      Table 2 - Contains Project ID, Multiple rows per ProjectID with different values of completion % i.e a project ID will have multiple rows with different values of Completion %.


      In a table in Qlik Sense, i create a column called 'Completed' to identify if a project is completed or not i.e. if for a Project ID, there is a row with completion % 100, it is complet.


      =If(CompletionPercentage = 100, 'Y', 'N')


      If i use the above expression i get 2 rows for each Project ID, one with value Y and one with value N.


      I understand that each row in the second table is being checked.


      Is there any other way to achieve this requirement?


      Yours Truly,