qlik pivot table

[alvaprajna]

Requirement:

I have following field emp_id,week,Project name,hours.

sample:

Emp:

load * inline

[

Name,id

Prajna,1

Chinmaya,2

];

Timesheet:

load *inline

[

id,week,Proj,hours

1,1,tis,8

1,1,sap,5

1,2,sap,7

1,2,training,0

2,1,training,0

2,1,tis,0

];

Now  i want the hours to be hidden for those employee who has zero planning hours for entire week and hide zero hours for those who has some value in the week.

Requirement.

Kindly assist.

Thanks,

Prajna

[alvaprajna]

[sunny_talwar]

May be like attached