Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kevbrown
Creator II
Creator II

Straight Table Tick or Cross

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

1 Solution

Accepted Solutions
kuba_michalik
Partner - Specialist
Partner - Specialist

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

View solution in original post

4 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

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
Creator II
Creator II
Author

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

kuba_michalik
Partner - Specialist
Partner - Specialist

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