topic Re: Set Analysis not working after covert to variable in App Development

Set Analysis not working after covert to variable

BrandonN — Sat, 31 Jul 2021 03:18:48 GMT

Hi All,

After I convert the expression to load inline as variable the expression not work .

Anyone can advise?

vFinalOutput

Thanks!

Re: Set Analysis not working after covert to variable

rubenmarin — Sat, 31 Jul 2021 07:09:13 GMT

Hi, the quick solution is to use replace to omit using characters like $ or ', to avoid to interpret them and just load the string, like:

LET vFinalOutput = Replace(Replace('Sum({<[DateMonth] = {|#(=#(vMaxYear))|}>}Record)','#','$'),'|',Chr(39));

So | will load as ' and # will load as $.

Another most common solution is using an external file to load variables with values assigned, loading from excel file also avoid the interpretation of $( or '.

https://community.qlik.com/t5/QlikView-App-Dev/Loading-variables-through-Excel-File/m-p/1263071

Re: Set Analysis not working after covert to variable

BrandonN — Mon, 02 Aug 2021 06:30:13 GMT

Thanks for sharing!