topic Problem when using if statement and count in same expression in QlikView

Problem when using if statement and count in same expression

Thu, 15 Mar 2012 15:36:06 GMT

Good Morning,

I need to use if statement and count in same expression. When using the following expression i'm getting no data.

=If(Identity = 'A', count(distinct{<Identity = {'A'}>}[ID]), If (Identity = 'B',count(distinct{<Identity = {'B'}>}[ID])))

Thu, 15 Mar 2012 15:38:38 GMT

the syntax is := count (if(condition,value))

Thu, 15 Mar 2012 15:42:56 GMT

Try putting the distinct after the set expression:

=If(Identity = 'A' , count({<Identity = {'A'}>}distinct [ID]),

If (Identity = 'B' , count({<Identity = {'B'}>}distinct [ID])))

Or you can create 2 expressions

count({<Identity = {'A'}>}distinct [ID])

count({<Identity = {'B'}>}distinct [ID])