LISTAGG Function Not working

Summary:

Hi Team,

Please help me debugging or optimize the below query.

Content (required):

The result:

The result I want:

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT

ican.candidate_number

,IRB.REQUISITION_NUMBER

,hqv.QUESTION_TEXT Question

,(case when HRA.LONG_TEXT is not null then LISTAGG(HRA.LONG_TEXT, '; ')

when HRA.LONG_TEXT is null AND haqrv.ANSWER_TEXT is null then 'No Answer'

else haqrv.ANSWER_TEXT end) Answer

FROM

IRC_CANDIDATES ican

,IRC_SUBMISSIONS isub

,HRQ_QSTNR_PARTICIPANTS hqp

,HRQ_QSTNR_PCPT_RESPONSES_V hqprv