Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

please help me with the if statement.

How can I put these 2 if statements in 1 if statement.

  if(match(CATEGORY,'4','9','16','21','22')=0,'Trust_Non-Reccuring','Trust_Reccuring') as FEETYPE

  if(ActualAccount <>0,'Trust Reccuring') as FEETYPE

Thanks in advance.

3 Replies
Highlighted
Not applicable

Re: please help me with the if statement.

Like this?

if(match(CATEGORY,'4','9','16','21','22')=0,'Trust_Non-Reccuring',if(ActualAccount <>0,'Trust Reccuring') ) as FEETYPE

 

Highlighted
MVP & Luminary
MVP & Luminary

Re: please help me with the if statement.

What's the value supposed to be if CATEGORY=4 and ActualAccount=0?

-Rob

Highlighted
MVP
MVP

Re: please help me with the if statement.

not fully understand the logic of your inquiry, however you can combine and, or, and nested if, for example,

=

if(match(CATEGORY,'4','9','16','21','22')=0 or ActualAccount=0, 'Trust_Non-Reccuring',

if(match(CATEGORY,'4','9','16','21','22')=1 or ActualAccount <>0, 'Trust_Reccuring',

'???'))