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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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