topic How to display image based on userid in QlikView

How to display image based on userid

Anonymous — Wed, 18 Mar 2015 17:04:24 GMT

Hi All,

I've textbox for displaying user name based user id and now trying to display image based on same user id but its not showing image.

For Displaying User Name :

=mid(OSUser(),9) in document properties -->Triggers and

in Text Object --> General Tab

=if(userid='98765765','Jack',(if(userid='98765565','Nileson','Guest')))

The same method used for displaying image but showing image path only

=if(userid='98765765','C:\Users\98765765\Desktop\one.png',(if(userid='98765565','C:\Users\98765565\Desktop\two.png','C:\Users\Guest\Desktop\three.png')))

Even i tried based on conditional display, its not working.

How can i display image based on user id?

Re: How to display image based on userid

Gysbert_Wassenaar — Wed, 18 Mar 2015 17:30:00 GMT

You can't use an expression to specify a background image for a text box using the Background->Image option.

What you can do is load the images with an INFO (or BUNDLE) load into the qlikview document itself and then reference the images stored in that table. See this document for how to do that: QlikView Technical Brief - Loading Images into QlikView.zip

Re: How to display image based on userid

stigchel — Wed, 18 Mar 2015 17:30:33 GMT

In the text box properties general tab set the representation option to Image

Re: How to display image based on userid

stigchel — Wed, 18 Mar 2015 17:38:19 GMT

I do agree with Gysbert that this is not the best way, it would be useless on any other computer with images on your C drive. But it is possible to display the text/link from a textbox as image (there is indeed no expression for the background image).