6 Replies Latest reply: Mar 24, 2018 1:51 AM by sai kishore RSS

    Show two fields concatenated in Filterpane Qliksense

    Supriya R

      Hi,

       

      I have a script like below

       

      LOAD `batch_meta_data_id`,

          `batch_name`,

      client_id;

      FROM BATCHMETADATA;

       

      LOAD `client_id`,

          `client_name`;

      FROM CLIENT;

       

      Now i need to show batch_name with its client_name appended in Filterpane.  But selection will be same , according to batch name selection. Just i need to append client name to batch name. Without effecting its normal functionality.

       

      Table:

      Load * INLINE [

      client_name ,batch_name

      Biscuits,britania

      Biscuits,krackzak

      Chocolate,cadbaury

      Chocalate,Kitkat

      ]


      In Filterpane when i apply, batch name. Batchname should show along with clientname

      Expected Output

      Biscuits- britania

      Biscuits- krackzak

      Chocolate- cadbaury

      Chocalate- Kitkat