topic Conditional show on a sheet in QlikView

Conditional show on a sheet

francisvandergr — Thu, 24 Mar 2011 08:03:15 GMT

USERID='SEGERS' or
USERID='ADMIN'

I have used this conditional show on my sheet. It works for SEGERS but not for Admin. When i do ADMIN first and then SEGERS, it works good for ADMIN. How is my formula for more users ?

Conditional show on a sheet

pat_agen — Thu, 24 Mar 2011 08:21:44 GMT

hi,

try

if(match(USERID,'SEGERS','ADMIN')>0,1,0)

that should work and the afterwrads youjust add other userids.

Conditional show on a sheet

Miguel_Angel_Baeyens — Thu, 24 Mar 2011 08:25:24 GMT

Hello Francis,

Try the following:

MATCH(USERID, 'SEGERS', 'ADMIN')

That will return greater than zero if there is a match, otherwise zero.

Hope that helps.

Conditional show on a sheet

francisvandergr — Thu, 24 Mar 2011 08:54:39 GMT

Thnx it works !