Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sashokku
Contributor

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?

shraddha_g
Honored Contributor III

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'))

Community Browser