topic Re: How to write Expression in Text Object in QlikView

How to write Expression in Text Object

Wed, 25 Mar 2015 21:21:46 GMT

Hi,

I am using a Text object to display, either a green "Check" image, if the expression is TRUE, and same Text object must display a red "X" image if the expression is not true. I included this logic in the "Text" right mouse click -> Properties -> General tab -> Edit Expression box, but it does not work. I may not be using the right syntax. Can someone please suggest?

Table1:

Load

* INLINE [
Room, Error

Room 1, 0

Room 2, 0

Room 3, 1];

The table looks like this:

Room	Error
Room 1	0
Room 2	0
Room 3	1

I selected a "Text" object. In text object "Properties" -> General tab -> within "Text" box, I want to type an expression or logic in the text object, that displays:

a green check image, if Room = Room 1 and Error = 0, otherwise the object will display a Red X image

Similary, there will be three separate Text objects for three rooms. Room 1 and Room 2 will display green checks and Room 3 will display red X.

Expression for green checkbox = 'qmem://<bundled>/BuiltIn/check_g.png','qmem://<bundled>/BuiltIn/cross_r.png')

Expression for red X = 'qmem://<bundled>/BuiltIn/cross_r.png'

This logic works in other Chart Type. I am able to execute this expression in Chart, by selecting Guage chart type, and in Properties select horizontal Traffic Light "Style".

Dimension: =if([Room]='Room 1',[CV-190 Room])

Expression: Error

This works perfectly, but it gives me only Round green and Round Red options. I prefer to use the green Check image and Red X image that is already available in "Edit Expression" -> "Images" tab

Thanks in advance

Re: How to write Expression in Text Object

fred_s — Wed, 25 Mar 2015 21:30:21 GMT

Hi Raghavendra,

Change representation to image and try again.

Grtz Fred

Re: How to write Expression in Text Object

Wed, 25 Mar 2015 21:38:48 GMT

Hi Fred,

Thanks for your quick response. I am already using Image "representation". I want to know the syntax that can be used in the "Text" box field that is located above the "Representation" field. The logic must do following:

If((Room = 'Room 1') and (Error = 0), 'green checkbox', 'red x').

Raghu

Re: How to write Expression in Text Object

fred_s — Wed, 25 Mar 2015 21:50:57 GMT

You could do something like this:

=if(sum({<Room={'Room 3'} >} Errorx) > 0, 'qmem://<bundled>/BuiltIn/cross_r.png' , 'qmem://<bundled>/BuiltIn/check_g.png')

Grtz Fred

Re: How to write Expression in Text Object

Thu, 26 Mar 2015 14:15:56 GMT

Hi Fred,

I used following:

if(Sum({<Room={'Room1'} >} Error) =0, 'qmem://<bundled>/BuiltIn/check_g.png','qmem://<bundled>/BuiltIn/cross_r.png')

I get the green check, but when I replace Room1 with Room3, I am supposed to see Red X, but instead I see green check.

The three Text Objects for three rooms must display:

Thanks,

Raghu

Re: How to write Expression in Text Object

fred_s — Thu, 26 Mar 2015 14:53:48 GMT

Try 'Room 3' (space between Room and 3) instead of 'Room3'.

Grtz Fred

Re: How to write Expression in Text Object

Thu, 26 Mar 2015 15:02:20 GMT

Hi Fred,

Thanks for your earlier suggestions.

The following works:

if(sum({<Room={'Room 1'}>} Error) =0, 'qmem://<bundled>/BuiltIn/check_g.png','qmem://<bundled>/BuiltIn/cross_r.png')

Thanks,

Raghu

Re: How to write Expression in Text Object

fred_s — Thu, 26 Mar 2015 16:35:35 GMT

Please mark this question as answered.

Thanks