Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dmxmikey
Creator
Creator

script to return image if its a certain value

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()),'-')

6 Replies
ThornOfCrowns
Specialist II
Specialist II

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

dmxmikey
Creator
Creator
Author

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...

stigchel
Partner - Master
Partner - Master

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.

stigchel
Partner - Master
Partner - Master

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.

ashfaq_haseeb
Champion III
Champion III

Hi,

Check this too.

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

Regards

ASHFAQ

dmxmikey
Creator
Creator
Author

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.