Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
"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.