topic How to set a default image in QlikView

How to set a default image

Tue, 08 Feb 2011 06:12:19 GMT

Hi all,

I want to display profile picture of employees when I select the Employee name from a list box. But for some employees there is no image available in the database. For such employees I want to display a default image. How can I do this? Please help me on this.

Thank You!

How to set a default image

disqr_rm — Tue, 08 Feb 2011 07:59:39 GMT

In your loading script you must be loading a mapping table for employee and the path\filename for employee picture. If so, you may add if condition in your load script to find if employee picture exists and load that, otherwise you can load a default image - image not available or something.

So briefly:

LOAD EmpName,

if(FileTime('c:\images\' & EmpName & '.jpg') > 0, 'c:\images\' & EmpName & '.jpg', 'c:\images\' & 'defualt.jpg') as EmpImage,

….

FROM ….

WHERE…

Hope this helps.

How to set a default image

Tue, 08 Feb 2011 08:17:34 GMT

Thanks a lot Rakesh... It works fine 🙂