conditional show/hide of object based on table value

[Qlik_Enthu]

hi all,

I have a requirement to show an object ( nothing but the image of batch completion status - green, yellow or red) based on the values of two fields from a table. the query will return the two columns. based on the combination values I have to show any one of the three objects.

how to achieve this?

TIA!

Regards,

Sai

[vinieme12]

go to the layout tab in the properties of the object and set Conditional and enter your condition to show / hide the chart for example

     conditional  =  if( sum(value)>100,1,0)

here if sum(Value)>100 then the object will be visible else hidden

[Qlik_Enthu]

I have to check combination values of two field, that is if error count=0 and field B='Successful' then show green

similarly two other conditions for other two objects. but if I give the if statement in conditional edit expression window, =IF(ErrorCount=0 AND field B='successful',1,0)  it says bad field names. can u please tell me what wrong am I doing here?

[Anil_Babu_Samineni]

Yes, field B should be within the square bracket

If (ErrorCount = 0 and [field B] = 'successful', 1, 0)

[vinieme12]

So ErrorCount and field B are fields?

So will you be making any kind of selections so that ErrorCount and field B return a single value?

because if any of these fields return multiple values your condition will not work and you really need an aggregation function like Sum or Max in such cases

Example

=IF(Max(ErrorCount)=0 AND  count({<[field B]={'successful'}>} [field B])>1,1,0)

[Qlik_Enthu]

dear all still my problem is not solved. my condition as follows:

in the general text property I gave: =if(GetSelectedCount(ERRORCOUNT=0) or GetFieldSelections(CODE_VAL_CHAR='B'),1,0)

and in layout conditional I gave vShowCS=1 (variable)

However, the conditions are not giving the expected output. can someone pls help?

tia!

[Anil_Babu_Samineni]

Try this?

=if(GetSelectedCount(ERRORCOUNT)=0 or Match(GetFieldSelections(CODE_VAL_CHAR),'B'),1,0)

[effinty2112]

Hi Samimeenakshi,

Maybe you're looking for something like this:

Pick(

Match(-1,

GetSelectedCount(ERRORCOUNT)=0 and GetFieldSelections(CODE_VAL_CHAR)='B',

GetSelectedCount(ERRORCOUNT)=0 or GetFieldSelections(CODE_VAL_CHAR)='B',

-1,),

Green(),

Yellow(),

Red())

If both conditions are met then Green, if only one is met then Yellow and if neither is met then Red.

Cheers

Andrew

[Qlik_Enthu]

I am getting all three objects appearing after gving the below expression

Pick(

Match(-1,

GetSelectedCount(ERRORCOUNT)=0 and GetFieldSelections(CODE_VAL_CHAR)='B',

GetSelectedCount(ERRORCOUNT)=0 or GetFieldSelections(CODE_VAL_CHAR)='B',

-1,),

Green(),

Yellow(),

Red())

[Qlik_Enthu]

all three becomes hidden if I use this