Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator II
Creator II

How to get the right table value after join ?

Hi there ,

I have two tables -

ashmitp869_0-1634178304704.png

 

where join the two table I am getting the below using the script

EDBreaches:
right keep(WARD_EPISODE)
load WARD & '-'& hour([Arrival DateTime]) as [Ward Episode Arrival DateTime Hours]
,Sum([ETP Denominator] - [ETP Numerator]) as EDBreaches
resident ED
where [Departure Date] >= Date(Today()-29)
group by WARD,hour([Arrival DateTime])
;

ashmitp869_1-1634178363256.png

But I want the value of Arrival Hour - 0,1,2,3 from the second table after join ?

0 Replies