Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Show excluded values for a given date

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

USER_ID, 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?

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

Hi

have a look at the attach example

this expression will work in a table

Maxstring({<DATE=, USER_ID=e(USER_ID)>}USER_ID)

View solution in original post

3 Replies
lironbaram
Partner - Master III
Partner - Master III

Hi

have a look at the attach example

this expression will work in a table

Maxstring({<DATE=, USER_ID=e(USER_ID)>}USER_ID)

Anonymous
Not applicable
Author

Hi Deshani,

Please refer the below Attached application for creating a table according to your requirements.

Hope this helps.

Thanks,

Balkamal Singh

Anonymous
Not applicable
Author

Hi Liron,

Thank you! The expression was what I just needed. Thank you once again