2 Replies Latest reply: Jan 3, 2013 11:52 AM by Jeannie Chi RSS

    excel as pass-through value in sql statement in qlikview

      Hi there,

       

      Does anyone know if there is a way I can use excel spreadsheet as one of my value in case-when statement in qlikview ?

       

       

      TABLE_A:

      LOAD     NEW_var

      ;

      SQL

      select case

                       when x in (a,b,c,d, ... zzz )   then 'value'

                       when x = zz0                       then 'no-value'

                 end as NEW_var

      from sql.table

      ;

      STORE TABLE_A into TABLE_A.QVD (qvd);

       

       

      say from this code below , I have (a,b,c,d....zzz) store in "file.xlsx" excel file  as "value"

       

      value
      a
      b
      c
      :
      :
      zzz

       

      I'm new to qlikview, let me know if this is possible.