https://community.qlik.com/t5/QlikView/Data-need-in-that-way/m-p/1682153#M450147 What is for example the logic to have 'Benefits Investigation/Prior Authorization' on the same line as:<BR />'Patient Foundation 6/25/2019 2151894' ?? Thu, 05 Mar 2020 15:50:16 GMT jochem_zw 2020-03-05T15:50:16Z https://community.qlik.com/t5/QlikView/Data-need-in-that-way/m-p/1681899#M450128 <P>I have data like below&nbsp;</P><TABLE width="517"><TBODY><TR><TD width="78">Patient ID</TD><TD width="254">Service Request Type</TD><TD width="103">SR Created Date</TD><TD width="82">CaseNumber</TD></TR><TR><TD>PAT-188149</TD><TD>GATCF Patient Assistance</TD><TD>4/19/2016</TD><TD>435031</TD></TR><TR><TD>PAT-188149</TD><TD>Benefits Investigation/Prior Authorization</TD><TD>4/4/2018</TD><TD>1118864</TD></TR><TR><TD>PAT-188149</TD><TD>GATCF Patient Assistance</TD><TD>4/9/2018</TD><TD>1125219</TD></TR><TR><TD>PAT-188149</TD><TD>Patient Foundation</TD><TD>12/8/2018</TD><TD>1634660</TD></TR><TR><TD>PAT-188149</TD><TD>Benefits Investigation/Prior Authorization</TD><TD>4/6/2019</TD><TD>18197</TD></TR><TR><TD>PAT-188149</TD><TD>Patient Foundation</TD><TD>6/25/2019</TD><TD>2151894</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How can i achieve my data like this in qlikview .&nbsp;</P><TABLE width="890px"><TBODY><TR><TD width="75.2px">Out put</TD><TD width="244.8px">&nbsp;</TD><TD width="101.6px">&nbsp;</TD><TD width="81.6px">&nbsp;</TD><TD width="248px">&nbsp;</TD><TD width="70.4px">&nbsp;</TD><TD width="67.2px">&nbsp;</TD></TR><TR><TD width="75.2px">PAT-188149</TD><TD width="244.8px">Patient Foundation</TD><TD width="101.6px">6/25/2019</TD><TD width="81.6px">2151894</TD><TD width="248px">Benefits Investigation/Prior Authorization</TD><TD width="70.4px">4/6/2019</TD><TD width="67.2px">18197</TD></TR><TR><TD width="75.2px">PAT-188149</TD><TD width="244.8px">Patient Foundation</TD><TD width="101.6px">12/8/2018</TD><TD width="81.6px">1634660</TD><TD width="248px">Benefits Investigation/Prior Authorization</TD><TD width="70.4px">4/4/2018</TD><TD width="67.2px">1118864</TD></TR><TR><TD width="75.2px">PAT-188149</TD><TD width="244.8px">GATCF Patient Assistance</TD><TD width="101.6px">4/9/2018</TD><TD width="81.6px">1125219</TD><TD width="248px">Benefits Investigation/Prior Authorization</TD><TD width="70.4px">4/4/2018</TD><TD width="67.2px">1118864</TD></TR><TR><TD width="75.2px">PAT-188149</TD><TD width="244.8px">GATCF Patient Assistance</TD><TD width="101.6px">4/19/2016</TD><TD width="81.6px">435031</TD><TD width="248px">&nbsp;</TD><TD width="70.4px">&nbsp;</TD><TD width="67.2px"><P>&nbsp;</P></TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 01:07:48 GMT https://community.qlik.com/t5/QlikView/Data-need-in-that-way/m-p/1681899#M450128 vipin_mishra479 2024-11-16T01:07:48Z https://community.qlik.com/t5/QlikView/Data-need-in-that-way/m-p/1682153#M450147 What is for example the logic to have 'Benefits Investigation/Prior Authorization' on the same line as:<BR />'Patient Foundation 6/25/2019 2151894' ?? Thu, 05 Mar 2020 15:50:16 GMT https://community.qlik.com/t5/QlikView/Data-need-in-that-way/m-p/1682153#M450147 jochem_zw 2020-03-05T15:50:16Z