Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator
Creator

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