topic Re: Can anyone help please? in QlikView

Can anyone help please?

Thu, 07 Nov 2013 11:15:36 GMT

Hello all,

I have a query which I hope will be simple!!

I have a field named GROUPNAME and I'd like to conditionally hide a text box if a value within the GROUPNAME equals 'AEUSERS'.

I've been trying the match function but I can't get it to work, I feel like I'm so close!

Any help is greatly appreciated.

israrkhan — Thu, 07 Nov 2013 11:28:31 GMT

try below: in conditional show

=If(GROUPNAME ='AEUSERS',1,0)

Thu, 07 Nov 2013 11:37:04 GMT

That does hide the text box but only if the value 'AEUSERS' is selected.

That isn't what I want, I want to hide the box if 'AEUSERS' exists in the field, without selecting anything.

Thu, 07 Nov 2013 11:47:22 GMT

It must be easy to identify if there is a value in a field. For instance get 1 or 0 if AEUSERS exists in your column or get the number it shows up.

Then you will set a variable to get this value. In your box you will set a conditional variable=....

bruno_m_santos — Thu, 07 Nov 2013 11:51:07 GMT

Try

If(FieldIndex('GROUPNAME','AEUSERS') >0 ,1,0)

Thanks

Bruno

israrkhan — Thu, 07 Nov 2013 11:53:45 GMT

THEN LOAD IN THE SCRIPT LIKE BELOW:

LOAD ABC,

EDC,

IF(GROUPNAME ='AEUSERS', 1,0) as Flag

FROM ....

THEN IN THE TEXT BOX USE EXPRESSION LIKE BELOW:

IF(Flag =1,1,0)

WILL; WORK....

Thu, 07 Nov 2013 12:06:17 GMT

You can make your object show/hide by a conditional variable=1

Then you set your variable value as

=If(FieldIndex('GROUPNAME','AEUSERS') >0 ,1,0)

If it exists in the field you will get 1 and the object will appear.