Pivot table output

[#1]

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

[CarlosAMonroy]

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

[#3]

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

[CarlosAMonroy]

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