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,

      S.Manikantan