Qlik Technology Partners Ecosystem
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.