topic Re: Scripting Assistance for Variable in App Development

Scripting Assistance for Variable

QFanatic — Mon, 27 Mar 2023 14:44:08 GMT

Hi all,

Silly question this one.

Please paste the below code in an empty QlikView file. My Code fails on the 'Match' statement. I need some assistance to get this to work please, and I've tried all options I can think of.

Thank you

Tbl:
load
chr(40) & concat(Code, ',') & chr(41) as Codelist;
LOAD * INLINE [
Code
28
29
30
];
Let MyVar = FieldVAlue('Codelist',1);
drop table Tbl;

DemoData_1:
LOAD * INLINE [
Student, Code
Peter, 28
Pam, 88
Paul, 30
];

DemoData:
NoConcatenate load
*
Resident
DemoData_1
where match(Code, $(MyVar)) > 0 ; //this is where it fails - I've also tried $(MyVar), with no luck - it runs, but returns nothing

drop table DemoData_1;

exit SCRIPT

Re: Scripting Assistance for Variable

Or — Mon, 27 Mar 2023 15:03:49 GMT

Try '$(MyVar)'

Otherwise, run it in debug mode and see if the variable is assigned correctly in the first place.

Re: Scripting Assistance for Variable

maxgro — Mon, 27 Mar 2023 16:21:47 GMT

your variable after the first styatement is (28,29,30)

maybe with

where Index('$(MyVar)', Code)

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/Index.htm

Re: Scripting Assistance for Variable

QFanatic — Mon, 27 Mar 2023 16:39:01 GMT

Thank you - this works!