topic conditional show/hide of object based on table value in QlikView

conditional show/hide of object based on table value

Qlik_Enthu — Fri, 11 Aug 2017 11:08:29 GMT

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

Re: conditional show/hide of object based on table value

vinieme12 — Fri, 11 Aug 2017 13:00:38 GMT

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

Re: conditional show/hide of object based on table value

Qlik_Enthu — Fri, 11 Aug 2017 17:32:20 GMT

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?

Re: conditional show/hide of object based on table value

Anil_Babu_Samineni — Fri, 11 Aug 2017 17:36:47 GMT

Yes, field B should be within the square bracket

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

Re: conditional show/hide of object based on table value

vinieme12 — Sat, 12 Aug 2017 15:50:09 GMT

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)

Re: conditional show/hide of object based on table value

Qlik_Enthu — Wed, 23 Aug 2017 08:32:44 GMT

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!

Re: conditional show/hide of object based on table value

Anil_Babu_Samineni — Wed, 23 Aug 2017 08:38:19 GMT

Try this?

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

Re: conditional show/hide of object based on table value

effinty2112 — Wed, 23 Aug 2017 08:45:40 GMT

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

Re: conditional show/hide of object based on table value

Qlik_Enthu — Wed, 23 Aug 2017 09:51:52 GMT

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())

Re: conditional show/hide of object based on table value

Qlik_Enthu — Wed, 23 Aug 2017 09:59:44 GMT

all three becomes hidden if I use this

Re: conditional show/hide of object based on table value

effinty2112 — Wed, 23 Aug 2017 10:08:47 GMT

Hi,

I suggest deleting two of the icons and make the image on the remaining conditional. Something like:

Pick(

Match(-1,

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

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

-1,),

'qmem://<bundled>/BuiltIn/check_g.png',

'qmem://<bundled>/BuiltIn/exclamation_y.png',

'qmem://<bundled>/BuiltIn/cross_r.png')

Good luck

Andrew