1 Reply Latest reply: Mar 9, 2018 4:08 AM by Kevin Alvino RSS

    Display records based on given expression in qliksense

    Supriya R

      Hi,

       

      INVITATION:

      LOAD * INLINE [

      unique_id,batch_id

      2334,2

      3223,2

      ];


      USERQUESTION:

      LOAD * INLINE [

      question_id,answer_choiced_id as answerID,unique_id, question type,user_answer

      311,2,2334,multiple,

      312,1,2334,multiple,

      313,0,2334,freeform, I was so sick that i had surgery.

      311,4,3223,multiple,

      312,5,3223,multiple,

      313,0,3223,freeform,i am unemployeed, lost both part time jobs

      ];


      ANSWERTEXT:

      LOAD * INLINE [

      answer_id as answerID, answertext

      2,short on cash

      1,too late

      4, stuck on bills

      5, none above

      7, no work

      3,late payment

      ];

       

      My required output

      unique_idmultiple question 1multiple question 2freeform
      2334short on cashtoo lateI was so sick that i had surgery.
      3223stuck on billsnone abovei am unemployeed, lost both part time jobs

       

       

      I am using dimensions:

      Dimension1 :multiple question 1 (i.e question num 311): if(match(question_id,'311'), answertext)

      Dimension2 : multiple question 2 (i.e question num 312): if(match(question_id,'312'), answertext)

      Dimension3 : freeform (i.e question num 313): if(match(question_id,'313'),user_answer)


      But i am able to view only one question field(that question could be any question which is first put), other questions field shows null.


      How could i do this in straight Table?