topic script to return image if its a certain value in QlikView

script to return image if its a certain value

dmxmikey — Thu, 06 Nov 2014 16:06:03 GMT

below is my script and would like to amend it so that the result shows as an image instead of "Y"

=agg (concat (DISTINCT if ([code]='EGG', if ([status]='Y','Y',),null()),'-')

Re: script to return image if its a certain value

ThornOfCrowns — Thu, 06 Nov 2014 16:07:28 GMT

If the image has an ASCII number that's indeed possible.

Re: script to return image if its a certain value

dmxmikey — Thu, 06 Nov 2014 16:36:22 GMT

I would like to use the Tick in the images below, but haven’t got a clue how to

<http://www.thomasridley.co.uk/>

Mike Dube ACCA

Business Process Manager

T: 01359 270536

Favourite Dish: Lamb Stew and Dumplings<http://www.countryrange.co.uk/recipes/?ID=7> Follow us on Twitter<https://www.twitter.com/ThomasRidleyFS> <https://www.twitter.com/ThomasRidleyFS>

Delivering the best in Foodservice...

Re: script to return image if its a certain value

stigchel — Thu, 06 Nov 2014 16:47:49 GMT

For loading the pictures look at the "bundle info" load statement in the help. Then for using the loaded images in an expression look at the second expression in the object with the colored arrow in the attached example. This is one of the build in images, but the way and syntax is the same.

Re: Re: script to return image if its a certain value

stigchel — Thu, 06 Nov 2014 17:09:52 GMT

Here is an example with country flags with the bundle info in the load script and a listbox with an expression to display the loaded images (so in the expressions tab of the listbox). In this case the images are linked to the dimension country, so it will display the images for a listbox with country as field. Any expression resulting in the correct link to the loaded images will work, so you are not required to link your images to another field.

Re: script to return image if its a certain value

ashfaq_haseeb — Sun, 09 Nov 2014 06:39:45 GMT

Hi,

Check this too.

http://community.qlik.com/docs/DOC-3859

Regards

ASHFAQ

Re: script to return image if its a certain value

dmxmikey — Mon, 10 Nov 2014 16:14:42 GMT

Sorry am a bit new to scripting, basically what I need to do is for the results on the table its either a Y or N, so what i would like is to get the Y in a green background and N in red background.

Above is the script im using.