Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

deshania
New Contributor

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
Honored Contributor II

Re: Show excluded values for a given date

Hi

have a look at the attach example

this expression will work in a table

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

3 Replies
lironbaram
Honored Contributor II

Re: Show excluded values for a given date

Hi

have a look at the attach example

this expression will work in a table

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

balkamal
New Contributor II

Re: Show excluded values for a given date

Hi Deshani,

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

Hope this helps.

Thanks,

Balkamal Singh

deshania
New Contributor

Re: Show excluded values for a given date

Hi Liron,

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

Community Browser