Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try Checking Supress Zero values in the presentation tab of the table properties.
May be this
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.
I don't want to suppress all zero values.
Thanks,
Prajna
Would you be able to attach your qvw?
No I cant do that
Can you check with new data shared.
Thanks,
Prajna
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
];
!!I can share that
What is the output that you are looking to get in this case?