topic Re: qlik pivot table in QlikView

qlik pivot table

alvaprajna — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: qlik pivot table

Anonymous — Mon, 27 Mar 2017 14:31:16 GMT

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

Re: qlik pivot table

sunny_talwar — Mon, 27 Mar 2017 15:14:03 GMT

May be this

Re: qlik pivot table

alvaprajna — Tue, 28 Mar 2017 09:00:10 GMT

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.

Re: qlik pivot table

alvaprajna — Tue, 28 Mar 2017 09:01:25 GMT

I don't want to suppress all zero values.

Thanks,

Prajna

Re: qlik pivot table

sunny_talwar — Tue, 28 Mar 2017 10:58:37 GMT

Would you be able to attach your qvw?

Re: qlik pivot table

alvaprajna — Tue, 28 Mar 2017 11:07:10 GMT

No I cant do that

Can you check with new data shared.

Thanks,

Prajna

Re: qlik pivot table

sunny_talwar — Tue, 28 Mar 2017 11:38:19 GMT

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
];

Re: qlik pivot table

alvaprajna — Tue, 28 Mar 2017 11:48:03 GMT

!!I can share that

Re: qlik pivot table

sunny_talwar — Tue, 28 Mar 2017 11:56:32 GMT

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

Re: qlik pivot table

alvaprajna — Tue, 28 Mar 2017 12:13:40 GMT

Re: qlik pivot table

sunny_talwar — Tue, 28 Mar 2017 14:02:14 GMT

May be like attached