Calculate only when if condition is met.

[Yogita]

Hi,

I am new to QlikView. Need some help here.

I am trying to create an expression with the below logic:

 =count({$<Difference_LastversusCurrent-={''}>}DISTINCT EEUserName)/count(TOTAL {$<Difference_LastversusCurrent-={''}>}DISTINCT(EEUserName)) 

The above logic should work only if CRating is not equal to zero. What should be the final expression be with the if condition.

 Thanks

Yogita

[jduenyas · Accepted solution]

=IF(CRating<>0,count({$<Difference_LastversusCurrent-={''}>}DISTINCT EEUserName)/count(TOTAL {$<Difference_LastversusCurrent-={''}>}DISTINCT(EEUserName)) )

In QV there is not always a need to give the second option of an IF statement.

[Yogita]

Thank You !! This is working.