topic Re: Pivot table output in QlikView

Pivot table output

Wed, 25 Nov 2020 16:16:04 GMT

Input:

Name,Project,week,hours

w1,w2,w3

Prajna,Proj1,8,0,0

Prajna,Proj2,2,2,0

Prajna,Proj3,0,0,0

Ram,Proj1,0,0,0

Ram,Proj2,0,0,0

output:

w1,w2,w3

Prajna,Proj1,8,0,0

Prajna,Proj2,2,2,0

Ram,' ' ,0,0,0

Kindly help..tried lot of stuff..not working

Re: Pivot table output

CarlosAMonroy — Tue, 14 Mar 2017 14:02:49 GMT

Hi Prajna,

I'm not quite sure if I understand your question, but by default tables in QlikView does not show data when the expression result is 0. So if you do want to show 0 values or null values. You have to go to object properties and under Presentation tab just uncheck the 'Suppress Zero-Values' option.

Hope that helps, thanks.

Carlos M

Re: Pivot table output

Tue, 14 Mar 2017 14:16:14 GMT

nope,the problem what em facing is.. they want employees with entire planning hours zero for all week.

In case of employee prajna she has some entry for few weeks in that case i dont want to take zero hours hence i exclude proj3 .

But in case of employee Ram,there is no data for all the weeks.so i need to include him.

Regards,

Prajna

Re: Pivot table output

CarlosAMonroy — Tue, 14 Mar 2017 14:35:11 GMT

Ok, I got it now.

You can flag the Resources, Projects that do not have hours assigned during the weeks. And then use the flag in set analysis or you can use 'if' condition to show the data you want.

something like this: if sum(aggr(sum(hours),Project, Name, Week))=0,'NoData',sum(hours))

As you can see I'm using a text to flag those Names that do not have hours. If 0 is used you need to play with the presentation options in order to show what you need.

Hope that helps,

Carlos M