Qlik Community

Technology Partners Ecosystem Discussions

Qlik Technology Partners Ecosystem

Contributor III

How to use count aggr in backend in Qliksense

Hi Team,

Please suggest how to achieve the below task.

I have data Plant level and Unit wise. the status is based on Unit wise. Now i want show the status on Plants where the status at least one Status ='Y'. Example file attached. 

Example Plant XYZ having 2 units. There status 1C unit is N and status 1D is Y then XYZ Plant status should be 'YES'.

Atleast one status should be Y. 

Thanks in advance.