3 Replies Latest reply: Jul 11, 2017 6:47 AM by Friedrich Hofmann RSS

    Synthetic Key

    Agrim Sharma



      I want to achieve a result as shown below,

      I want to select month eg. July

      Then, I want to select role eg. “Admin SYS” 

      Then, I want to filter-“Assigned” from “type of Assignment” 

      Then, I want to know name of employee (Alexandre FAVRE)

      and its exact “Allocated/Assigned” Value=2


      I am getting correct results but there is one synthetic key


      Following is my Script with attached Data and Qlik Sense App:-