topic AW:Re: AW:Re: Showing boolean data as a check box or similar in QlikView

Showing boolean data as a check box or similar

Fri, 25 Feb 2011 11:49:44 GMT

Is there a way I can show a text value "True" as a text value "Y" or as an Icon or as a Checkbox.

I've tried the SQL case statement but the feed SQL doesn't like it and I've tried the column formatting and it doesn't allow.

Any other possibilities

Thanks

John

Showing boolean data as a check box or similar

Fri, 25 Feb 2011 11:53:19 GMT

if(data='Y',True,False)

Showing boolean data as a check box or similar

Fri, 25 Feb 2011 11:53:46 GMT

as an expression in a checkbox

Showing boolean data as a check box or similar

Fri, 25 Feb 2011 11:59:02 GMT

Sorry my question was not that well phrased, I wanted a check box or similar int a table view so instead of "True" or "False" in the columns it showed it graphically or simpler as "Y" or "N" ... in some I'd like to show nothing if false and a geen box / dot if true, or similar.

Showing boolean data as a check box or similar

Fri, 25 Feb 2011 14:17:07 GMT

I don't know if I understand your question but:

you can use the tab on properties graphic "layout": inside you can put a condition

AW:Re: Showing boolean data as a check box or similar

Fri, 25 Feb 2011 15:44:10 GMT

Hi John,

I think you should create an expression (eg in a straight table) with Display Option = "Image" (tab Presentation) and code it similar to this:

if(sum(Value) >=50, 'qmem://<bundled>/BuiltIn/led_g.png',
 if(sum(Value) >=25, 'qmem://<bundled>/BuiltIn/led_y.png',
 if(sum(Value) >= 10, 'qmem://<bundled>/BuiltIn/led_r.png'
 )
 )
)

Note: Build In Images like above can be found in the Image-Tab of the expression editor.

Regards, Roland

AW:Re: Showing boolean data as a check box or similar

Fri, 25 Feb 2011 16:57:16 GMT

Thanks for your help

As you may guess I'm new to QV - I'm using the Table Box object

Trying to locate where the display options are. I've located Advanced on the presentation tab which seems to be a suitable location but it doesn't allow teh If(,,) statement, Number with format pattern, but it does nothing with the If Statement and there is no image,

I want an column Available to show green when it is true (Text 'TRUE'). (I'll mess with the pics later - found that ok thanks)

John

(Available = "TRUE",'Y', '')

AW:Re: AW:Re: Showing boolean data as a check box or similar

Fri, 25 Feb 2011 21:12:19 GMT

Hi John,

a table box is like a view onto the fields you added. No calculation or representation can be done. So try to use for your purpose a chart --> choose straight table. See my little app, there you will find a exam straight table. Sorry, my describtion in my post above wasn't correct, here once again: see properties --> Expressions --> choose expression "example" --> Representation" is Image and see for the definition of the expression input field. AND --> Enjoy QV!

AW:Re: AW:Re: Showing boolean data as a check box or similar

Mon, 28 Feb 2011 14:06:18 GMT

Thanks Roland

Nearly there, but its pushing the formula not the result to the table column.

e.g. if(Hob='TRUE', ... led_g.png, ... led.png )

Getting

I think i'm looking for a checkbox somewhere to say 'Use Icon'

John

AW:Re: AW:Re: Showing boolean data as a check box or similar

Mon, 28 Feb 2011 15:38:44 GMT

Found it thanks

Formatting on the expression to 'Image' and then change the 'Display Option' to 'Image' set the aspect ratio and wait a bit while it saves.

Lovely