excel as pass-through value in sql statement in qlikview

[#1]

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.

[Gysbert_Wassenaar · Accepted solution]

Maybe like this:

load concat(value) as valuelist from file.xlsx (ooxml, embedded labels);

let vList = peek('valuelist');

TABLE_A:

LOAD     NEW_var

;

SQL

select case

                 when x in ($(vList))   then 'value'

                 when x = zz0                       then 'no-value'

           end as NEW_var

from sql.table

;

[#3]

thank you ! I'll give it a shot and I'll let you know. 🙂