Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

expression help

I Have two tables one is user another one is seesionlog

in session log  identyfy user name colume is present

in user   identify username column present

both have relation

now i need to get the  username value that is not present in the sessionlog table

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Create a straight table and add username as dimension and as expression count({<username={'=count(sessionid)=0'}>}1). Replace username with the name of your username field and sessionid with a field name from your session log table. You can hide the expression if you want.


talk is cheap, supply exceeds demand