Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

Nested if error

Can someone figure out what is wrong. It says ok but unable to visualize.

count (If(Match([R1],'A' ,

'B','C' 

),'Good')

and

If(Match([R2],'C','D', 'Good' ),'Good')

or

If(Match([R2]'C','D', 'Good' ),'Good')

and

If(Match([R3],'C',

'E','Good'))

count (If(Match([R1],'C' ,

'F'),'Good)

and

If(Match([R2],'E' ),'Good')

or

If(Match([R2],'E'),'Good')

and

If(Match([R3],'C',

'E'),'Good'))

Tags (1)
3 Replies
Employee
Employee

Re: Nested if error

‌looking at this you have two count clauses but no addition symbol between them.

Re: Nested if error

What exactly are you trying to count?

Partner
Partner

Re: Nested if error

count (If(Match([R1],'A' ,

'B','C' 

),'Good')

and

If(Match([R2],'C','D', 'Good' ),'Good')

or

If(Match([R2],'C','D', 'Good' ),'Good')

and

If(Match([R3],'C',

'E','Good'))

count (If(Match([R1],'C' ,

'F'),'Good)

and

If(Match([R2],'E' ),'Good')

or

If(Match([R2],'E'),'Good')

and

If(Match([R3],'C',

'E'),'Good'))