topic expression help in QlikView

expression help

Anonymous — Thu, 16 May 2013 07:16:57 GMT

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

Re: expression help

Gysbert_Wassenaar — Thu, 16 May 2013 10:13:56 GMT

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.