Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

byrnel0586
Contributor

Dual IF Statements

Hi,

Can someone tell me what I've done wrong here? The calculations do not work for 2016 after I added the additional 'or' statement.

=if(match(Year,'2016'),sum({<LOB_ID ={705,706,709,713}>}DENOMINATOR) or match(Year,'2017'),sum({<LOB_ID ={713,714,715}>}DENOMINATOR))

Thanks.

1 Solution

Accepted Solutions
mwoolf
Honored Contributor II

Re: Dual IF Statements

=if(match(Year,'2016'),sum({<LOB_ID ={705,706,709,713}>}DENOMINATOR),

     if( match(Year,'2017'),sum({<LOB_ID ={713,714,715}>}DENOMINATOR)))

2 Replies
mwoolf
Honored Contributor II

Re: Dual IF Statements

=if(match(Year,'2016'),sum({<LOB_ID ={705,706,709,713}>}DENOMINATOR),

     if( match(Year,'2017'),sum({<LOB_ID ={713,714,715}>}DENOMINATOR)))

byrnel0586
Contributor

Re: Dual IF Statements

Of course, thank you!

Community Browser