Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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

;


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

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

;


talk is cheap, supply exceeds demand
Not applicable
Author

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