How to stop a blank user being loaded into my document?

[#1]

Hello all

I have been working on a Sytem Monitor and there was a blank user appearing in the application.  After some investigation into the log files I had discovered the blank users was taking the Client Address of the Qlikview server.

I now want to stop this blank user from being loaded into the application.  I have tried  using the code below but when I reload it, I get a message saying Qlikview couldnt find the field 'Session_User'

LOAD

*,

Capitalize(Mid([Identifying user],Index([Identifying user],'\')+1,100))               AS Session_User,

* WHERE

Session_User <> ' '

;

FROM

$(SessionPath) (txt, utf8, embedded labels, delimiter is '\t', msq);

[#2]

Hi Stuart

you may use

len(trim(Session_user) ) <> 0

trim will remove blanks and let len = 0   so it won't be loaded

best regards

Chris

[#3]

I tried that and it is still saying it can't find the field.  I will work on this tomorrow to try and find a fix!

[Nicole-Smith · Accepted solution]

It's saying it can't find the field because it doesn't exist yet.  I think you need something like

WHERE len(trim(Capitalize(Mid([Identifying user],Index([Identifying user],'\')+1,100)) ))>0

[#5]

Thanks Nicole.  That works great, no more blank users for me .  Thank you both for your help.