11 Replies Latest reply: Mar 8, 2018 5:04 AM by Sunny Talwar RSS

    convert rows to columns in qlik

    Supriya R

      Hi,

       

      i have table like below

      subject_access_idinteractivity_type_idvalueinteractivity_type
      12341sentsent?
      12342mailedmailed?
      12343truestatus?
      12351not sentsent?
      12352mailedmailed?
      12353falsestatus?
      12361sentsent?

       

      i want to display like below

      subject_access_idsent?mailed?status?
      1234sentmailedtrue
      1235not sentmailedfalse
      1236sent

       

      how could i do this?

       

      load subject_access_id, interactivity_type_id ,value, interactivity_type;

      SQL SELECT `subject_access_id`,

          `interactivity_type_id`,

          value,

      interactivity_type

      FROM INTERACTIVITYDATA ;