Straight Table Tick or Cross

[kevbrown]

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

[jonathandienst]

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

[#3]

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

[kevbrown]

That works fine to an extent. The symbols are huge, can I make them smaller?

[kuba_michalik · Accepted solution]

Sure, change Image Formatting (under Representation) to "Keep Aspect"