This content has been marked as final. Show 2 replies
Does anyone know if there is a way I can use excel spreadsheet as one of my value in case-when statement in qlikview ?
when x in (a,b,c,d, ... zzz ) then 'value'
when x = zz0 then 'no-value'
end as NEW_var
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"
I'm new to qlikview, let me know if this is possible.