Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

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

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);

Tags (3)
1 Solution

Accepted Solutions
Highlighted

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

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

View solution in original post

4 Replies
Highlighted
Not applicable

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

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

Highlighted
Not applicable

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

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!

Highlighted

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

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

View solution in original post

Highlighted
Not applicable

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

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