topic excel as pass-through value in sql statement in qlikview in QlikView

excel as pass-through value in sql statement in qlikview

Thu, 03 Jan 2013 15:35:19 GMT

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.

Re: excel as pass-through value in sql statement in qlikview

Gysbert_Wassenaar — Thu, 03 Jan 2013 15:59:33 GMT

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

;

Re: excel as pass-through value in sql statement in qlikview

Thu, 03 Jan 2013 16:52:10 GMT

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