Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm looking to create a straight table for some data qualilty work. Instead of the field against, say, Ethnicity being a "Y" or "N" to state if the field has been populated or not i was hoping for a green tick or red cross. Doable?
Kev
Sure, change Image Formatting (under Representation) to "Keep Aspect"
Hi
Have an expression return a path to a bundled or built in image - something like
=If(...... , 'qmem://<bundled>/BuiltIn/cross_r.png', 'qmem://<bundled>/BuiltIn/check_g.png')
)
and set the Representation (on the Properties | Expression tab) to Image. You can select other built-in images from the Images tab at the bottom of the expression editor.
HTH
Jonathan
If you go into the function editor you will find a tab on the bottom left called images that lets you embed images preloaded into QV. All you need to do is write an expression using these bundled images:
=if(Ethnicity = 'Y','qmem://<bundled>/BuiltIn/check_g.png','qmem://<bundled>/BuiltIn/cross_r.png')
Then you need to set the presentation type to Image
That works fine to an extent. The symbols are huge, can I make them smaller?
Sure, change Image Formatting (under Representation) to "Keep Aspect"