Discussion board where members can get started with Qlik Sense.
I have two tables.
Table A has 3 fields : ID, USER_ID and DATE
ID, USER_ID, DATE
01, uid_001, 01-01-2016
02, uid_002, 01-01-2016
03, uid_001, 02-01-2016
04, uid_003, 02-01-2016
05. uid_004, 02-01-2016
Table B has 2 fields : USER_ID and USER_NAME
uid_001, user 01
uid_002, user 02
uid_003, user 03
uid_004, user 04
I need to display the users who are not available for a given date.
Ex: users uid_003 and uid_004 were not available on 01-01-2016
Can someone please guide me?
Go to Solution.
have a look at the attach example
this expression will work in a table
Please refer the below Attached application for creating a table according to your requirements.
Hope this helps.
Thank you! The expression was what I just needed. Thank you once again