topic Re: Straight Table Tick or Cross in QlikView

Straight Table Tick or Cross

kevbrown — Mon, 26 Jan 2015 13:07:36 GMT

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

Re: Straight Table Tick or Cross

jonathandienst — Mon, 26 Jan 2015 13:16:07 GMT

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

Re: Straight Table Tick or Cross

Mon, 26 Jan 2015 13:18:10 GMT

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

Re: Straight Table Tick or Cross

kevbrown — Mon, 26 Jan 2015 13:48:23 GMT

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

Re: Straight Table Tick or Cross

kuba_michalik — Mon, 26 Jan 2015 14:25:56 GMT

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