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

[Anonymous]

Try Checking Supress Zero values in the presentation tab of  the table properties.

[sunny_talwar]

May be this

[alvaprajna]

Thanks Sunny.

In Case the data is like below:

Timesheet:
load *inline
[
id,week,Proj,hours
1,1,acc,0
1,1,tis,0
1,2,sap,5
1,2,sap,7
1,2,training,0
2,1,training,0
2,1,tis,0


]; Then its not working I am getting acc data as well for emp prajna.

[alvaprajna]

I don't want to suppress all zero values.

Thanks,

Prajna

[sunny_talwar]

Would you be able to attach your qvw?

[alvaprajna]

No I cant do that

Can you check with new data shared.

Thanks,

Prajna

[sunny_talwar]

You can't share the app where you tested this?

Timesheet:
load *inline
[
id,week,Proj,hours
1,1,acc,0
1,1,tis,0
1,2,sap,5
1,2,sap,7
1,2,training,0
2,1,training,0
2,1,tis,0
];

[alvaprajna]

!!I can share that

[sunny_talwar]

What is the output that you are looking to get in this case?