Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
vipin_mishra479
Creator II
Creator II

Data need in that way

I have data like below 

Patient IDService Request TypeSR Created DateCaseNumber
PAT-188149GATCF Patient Assistance4/19/2016435031
PAT-188149Benefits Investigation/Prior Authorization4/4/20181118864
PAT-188149GATCF Patient Assistance4/9/20181125219
PAT-188149Patient Foundation12/8/20181634660
PAT-188149Benefits Investigation/Prior Authorization4/6/201918197
PAT-188149Patient Foundation6/25/20192151894

 

How can i achieve my data like this in qlikview . 

Out put      
PAT-188149Patient Foundation6/25/20192151894Benefits Investigation/Prior Authorization4/6/201918197
PAT-188149Patient Foundation12/8/20181634660Benefits Investigation/Prior Authorization4/4/20181118864
PAT-188149GATCF Patient Assistance4/9/20181125219Benefits Investigation/Prior Authorization4/4/20181118864
PAT-188149GATCF Patient Assistance4/19/2016435031  

 

Labels (1)
1 Reply
jochem_zw
Employee
Employee

What is for example the logic to have 'Benefits Investigation/Prior Authorization' on the same line as:
'Patient Foundation 6/25/2019 2151894' ??