Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Setting multiple conditions in a field via if statement

Hi Everyone,

Can someone tell me why this isn't working please? I remembered you have to use a pipe, but i think i've got the syntax wrong

=if(vUserLevel='Region' AND vUserRegion='Scandinavia',('Denamrk|Norway|Sweden'))

This is a Select in Field action behind a button that resets defaults.

Kind Regards,

Miles

Tags (3)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Setting multiple conditions in a field via if statement

Try =if(vUserLevel='Region' AND vUserRegion='Scandinavia','(Denmark|Norway|Sweden)')


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: Setting multiple conditions in a field via if statement

Try =if(vUserLevel='Region' AND vUserRegion='Scandinavia','(Denmark|Norway|Sweden)')


talk is cheap, supply exceeds demand
Not applicable

Re: Setting multiple conditions in a field via if statement

Cheers Gysbert, I knew I was nearly there!!!