5 Replies Latest reply: Nov 26, 2016 5:53 AM by Bassel Kh RSS

    Expression to get List1\List2

    Bassel Kh

      Dears,

      I'm new to Qlik sense, I faced this case, and I need your help please.

       

      I have the following table with data:

      ID ,  SRC

      ------------

      111,1

      111,1

      111,1

      123,1

      134,1

      678,1

      123,2

      123,2

      134,2

      999,2

       

      lets name the above table 'TBL'.

       

      I need to build an expression to get the following

      result1= 2 which means count(distinct TBL.ID) where SRC=1 and ID not in(TBL.ID where SRC=2),

      only ID=111,678 has SRC=1 and not exist for SRC=2

       

       

      result2= 1 which mean count(distinct TBL.ID) : SRC=2 and ID not in(TBL.ID where SRC=1)

      only ID=999 has SRC=2 and ID value not exist in SRC=1

       

      Note:

      I need this result regardless of the current selection.

       

       

       

      Also, can I build table chart and use one column to show the result IDs without count aggregation function?

      Thanks in advanced

       

       

      Bassel Kh.