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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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