11 Replies Latest reply: Jul 28, 2017 1:08 PM by Hari Nag RSS

    Set Analysis to Show Un Associated Records In Qlik Sense

    Hari Nag

      Hi I have a Requirement  in the Qlik Sense

       

      I have two tables

       

      Project Details:

        

      ProjectStandar Year
      12015
      22016
      32017

       

      Amount Details:

         

      ProjectAmount YearAmount
      1201610
      1201720
      1201830
      2201640

         

       

      I have a  Amount Year Filter where user will select as 2017

       

      He wants a  table to like this

       

        

      ProjectAmount
      120
      30

       

      He Wants 3 Project as Standard Year equals to Amount year with Amount as 0.

       

      Please help in this regard.

       

      Thanks

      Hari