topic Re: Dual IF Statements in QlikView

Dual IF Statements

byrnel0586 — Wed, 22 Jun 2016 15:14:39 GMT

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.

m_woolf — Wed, 22 Jun 2016 15:29:21 GMT

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

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

byrnel0586 — Wed, 22 Jun 2016 15:34:56 GMT

Of course, thank you!