topic Re: if loop with or condition in QlikView

if loop with or condition

manoranjan_d — Tue, 26 Sep 2017 11:56:31 GMT

Hi all,

below is my if loop condition

if(role_id='Adm' or 'Mgr' or 'Read' or 'User' or 'USER','USER','ADMIN') as ACCESS,

this conidtion is not working int he load script level.

for the value 'User' it showing ADMIN value.

let me know the issue on this

Re: if loop with or condition

Anil_Babu_Samineni — Tue, 26 Sep 2017 11:59:13 GMT

You have to declare fieldname to each value

if(role_id='Adm' or role_id='Mgr' or role_id='Read' or role_id='User' or role_id='USER','USER','ADMIN') as ACCESS,

Re: if loop with or condition

MarcoARaymundo — Tue, 26 Sep 2017 12:00:14 GMT

try this

if(match(role_id, 'Mgr', 'Read', 'User', 'USER', 'USER', 'ADMIN',

'if true',

'if false'

) as ACCESS,

Re: if loop with or condition

MarcoARaymundo — Tue, 26 Sep 2017 12:02:57 GMT

Opps!

if(match(role_id, 'Mgr', 'Read', 'User', 'USER', 'USER', 'ADMIN'),

'if true',

'if false'

) as ACCESS

Re: if loop with or condition

Anonymous — Tue, 26 Sep 2017 12:08:40 GMT

Hi Please use this

You have to use role_id each time

if(role_id='Adm' or

role_id='Mgr' or role_id='Read' or role_id='User' or role_id='USER',

'USER','ADMIN') as ACCESS,

Re: if loop with or condition

Kushal_Chawda — Tue, 26 Sep 2017 12:12:06 GMT

try this

if(match(lower(role_id) ,'adm' ,'mgr' ,'read' ,'user' ),'USER','ADMIN') as ACCESS,

Re: if loop with or condition

Colin-Albert — Tue, 26 Sep 2017 12:20:43 GMT

Use MixMatch() for a case insensitive test

if(MixMatch(role_id, 'Adm' , 'Mgr' , 'Read' , 'User'), 'USER', 'ADMIN') as ACCESS,

There are several match functions available match(). mixmatch() and wildmatch() depending on whether you want a case sensitive test, as case insensitive test or wildcard test.