3 Replies Latest reply: Oct 8, 2014 2:20 AM by Pradip Sen RSS

    List box issue

    Amit Saini

      Hi Folks ,

       

      I'm calling excel sheet with script below:

      LOAD  left(A,3) as Plant,

           B as Region,

           C as Plant_FullName,

           D as Business_Units

      FROM

      [F:\QlikView\Server\SourceDocuments\Operation\KPI Report\#Source\Flatfiles\Plant.xlsx]

      (ooxml, no labels, table is Sheet1);

       

       

      In list box I'm calling this expression :

      =Plant & ' - ' & Plant_FullName

       

      Output is:

       

       

      No idea why this '-' is present in list box , Kindly help here I don't want this - in Plant list.

       

      Thanks,

      AS