topic Re: Show value conditionally in QlikView

Show value conditionally

Tue, 03 Sep 2013 14:17:34 GMT

Hi,

I have a requirement to show Employee cost only if the number of employees in that project are higher than 5.

It is posible to find the distinct employee count but need help to find the distinct employee count in project?

if(Count( distinct EmployeeId)>5,$(CostOwn),0)

Thanks in advance,

Rahul

Tue, 03 Sep 2013 14:23:53 GMT

i have found one expression as below but it's still under testing.

=sum (aggr(if(Count(distinct EmployeeId)>5,$(CostOwn) ,0),ProjectId))

Nicole-Smith — Tue, 03 Sep 2013 14:24:32 GMT

To find a count in a project, there are two ways you could do it:

1. If Project is one of your dimensions, it will automatically find the count for just that project.

2. Use aggr() around your count function with Project as the dimension: aggr(Count(distinct EmployeeId), Project)