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

    Synthetic Key

    Agrim Sharma

      Hi,

       

      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:-