Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Script Logic

Just wondering if this will work?

Thanks

[ZTRPSTTEMP]:
SQL Select *
FROM ZTRPST
WHERE
Right([ZORDER],10) in (Select VBELN from VBAK)
;

[ZTRPST]// Time Reports - Spread Time Posted
Load
[ZTICKNO]   as [Ticket],
Left([ZOBJECT],8)  as EmpID,
Right([ZORDER],10) & [ZACTIVITY] as [%ContractItemKey],
Right([ZORDER],10)  as [Contract],
[ZACTIVITY]   as [Contrac Line],
[ZSTATUS]   as [Status]
[ZWDATE]   as [Date],
ZHOURS   as [Z_Hours],
ceil(ZHOURS, .01)  as [Hours],
round(ZHOURS, .01) as [Hours_Round],
floor(ZHOURS, .01) as [Hours_Floor]
Resident ZTRPSTTEMP
WHERE exists(Right([ZORDER],10), [VBELN])

21 Replies
vishsaggi
Champion III
Champion III

Yes, so can you see the fields VBELN and %Contract has few same values? Can you snapshot those field names and show us what you see?

tmumaw
Specialist II
Specialist II
Author

I'm so sorry I did not get back to you sooner.  I finally figured it out.  I have attached a copy of my entire script just in case it happens to anyone else.  Thanks for all your help and time.