How to write expression based on condition?

[#1]

Hi,

I have to write an expression in pivot table.

Dimension1: Label

Dimension2: Topper

Expression: Count(ID)

but the expression should need the condition as

If Label='Poppy' and Topper equal to any other value instead of Topper<>'Poppy' then the expression should show count(Id). how can I write the expression.

can anyone suggest me please.

Thanks.

[robert99]

"Aggregation is faster as compare to count with set analysis"

Are you sure. I would always use count. Even count distinct in preference to sum based on a blog post by Henric

http://community.qlik.com/blogs/qlikviewdesignblog/2013/10/22/a-myth-about-countdistinct

Does using set analysis make a difference. But even so I would still use count distinct.