topic Re: expression with '$(=)' in script in QlikView

expression with '$(=)' in script

antonaks — Thu, 22 Mar 2018 15:04:22 GMT

Hello everybody.

I encountered such a problem.

In the loading script, I set the variable:

SET vTEST = sum({<DateKey = {'$(=max(DateKey))'}>} SUM_IN_WITH_NDSmov);

But in after reload variable looks like this:

sum({<DateKey = {''}>} SUM_IN_WITH_NDSmov)

I asking for help.

With best regards,

Anton.

Re: expression with '$(=)' in script

sunny_talwar — Thu, 22 Mar 2018 15:08:14 GMT

Check here

Expression as a variable with $-sign expansion

big problem with variable and set analysi expression

Re: expression with '$(=)' in script

swuehl — Thu, 22 Mar 2018 15:19:14 GMT

I usually store these kind of variables in an Excel file using something like

http://www.qlikfix.com/2011/09/21/storing-variables-outside-of-qlikview/

which does also fix the dollar sign expansion issue.

Re: expression with '$(=)' in script

antonaks — Thu, 22 Mar 2018 15:30:14 GMT

Thank you.

I already solved my problem with "excel solution". But now I'm wondering how to correctly declare a variable in the load script.

Re: expression with '$(=)' in script

sunny_talwar — Thu, 22 Mar 2018 15:33:35 GMT

The two links that I have shared have 2 different techniques listed in them... have you looked at them?

Re: expression with '$(=)' in script

Peter_Cammaert — Thu, 22 Mar 2018 15:40:14 GMT

Keep in mind that as long as you do not literally quote the string with dollars in your script, the $() won't get expanded.

You can pass around using variables and/or fields in statements any string with $()'s that should not be expanded. $-expansion will not happen on variable or field content, only on statement syntax inside your script and by the script engine (more precisely by a sort of pre-processor inside the parser) and before the statement is evaluated.

Functions also don't bother with $-sign expansion.

Re: expression with '$(=)' in script

antonaks — Thu, 22 Mar 2018 15:41:24 GMT

Thank you.

I'm studying your material now.

Re: expression with '$(=)' in script

antonaks — Thu, 22 Mar 2018 16:12:59 GMT

I solved problem with.

SET _varName = vTEST;

SET _varValue = sum({<DateKey = {'@(=max(DateKey))'}>} SUM_IN_WITH_NDSmov);

LET [$(_varName)] = Replace('$(_varValue)','@','$');

Thank you!