This content has been marked as final. Show 5 replies
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
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
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