SET doesn't evaluate inner SetExpression

[JustinDallas]

Hello Folks,

In my load script, I have some variables declared that I use in my app and NPrinting.  The bulk of them work just fine, but when I get to this one:

SET vTractorCount = COUNT({<[CalDate]={"$(=Min(CalDate))"}>} [Tractor Number])

I'm finding that QlikSense isn't evaluating that inner term of {"$(=Min(CalDate))"} .  It shows that the term is {""}.  However, when I copy and paste my SA into a KPI component, it works like a charm.

What am I missing with why Qlik doesn't like that inner term in my Set Analysis variable?

Any help is greatly appreciated.

[GaryGiles · Accepted solution]

You may want to try using a LET statement and building it as a string.  Then you can prevent the $ expansion from occuring in your load script:

LET vTractorCount = 'COUNT({<[CalDate]={"$'&'(=Min(CalDate))"}>} [Tractor Number])';

[JustinDallas]

It worked.  I don't like it, but it worked as expected!