topic Re: Putting a Set Analysis Expression into a Variable in QlikView

Putting a Set Analysis Expression into a Variable

Anonymous — Wed, 03 May 2017 18:05:29 GMT

How do I make a double-quoted string expand properly in a variable?

I have this:

SET vFieldName = ComplianceStatus;
SET vFieldCount = (GetSelectedCount($(vFieldName)) + GetAlternativeCount($(vFieldName)));
SET vSelectAllOrNone = GetSelectedCount($(vFieldName))=0 OR GetSelectedCount($(vFieldName))=$(vFieldCount);
SET vSubSelectColor1 = ONLY({<CompName={"$(=TRIM(SUBFIELD(GetFieldSelections($(vFieldName)),',',1)))"} >} CompColor);

Then, I have this:

SET vColor1 = IF($(vSelectAllOrNone), CompColor1, $(vSubSelectColor1));

The variable vSubSelectColor1 looks like this when I inspect it:

ONLY({<CompName={""} >} CompColor)

In vColor1, I'm expecting it to look like it does as I defined it. How do I make that happen?

Re: Putting a Set Analysis Expression into a Variable

Anonymous — Wed, 03 May 2017 18:12:01 GMT

I think this is the same problem essentially:

Set analysis in a variable, with dynamic field value in another variable

Re: Putting a Set Analysis Expression into a Variable

Anonymous — Wed, 03 May 2017 18:21:19 GMT

If it is, it is unclear how to resolve it.

Re: Putting a Set Analysis Expression into a Variable

neelamsaroha157 — Wed, 03 May 2017 18:23:54 GMT

Does vFieldname returns multiple values?

Your expression works if you have one of the value selected in a field.

Re: Putting a Set Analysis Expression into a Variable

Anonymous — Wed, 03 May 2017 18:39:24 GMT

No - vFieldName is simply a way to generalize the code so it can be re-used elsewhere with little modification. It returns the one value I assigned to it (the name of the field in question).

Re: Putting a Set Analysis Expression into a Variable

sunny_talwar — Wed, 03 May 2017 23:27:49 GMT

I think the issue is with the expansion of the dollar sign expansion

Expression as a variable with $-sign expansion

LET vSubSelectColor1 = 'Only({<CompName={"$' & '(=TRIM(SUBFIELD(GetFieldSelections($' & '(vFieldName)),',',1)))"}>} CompColor)';

Re: Putting a Set Analysis Expression into a Variable

Anonymous — Thu, 04 May 2017 11:32:27 GMT

That resulted in the error " Garbage after expression 's' "

Re: Putting a Set Analysis Expression into a Variable

sunny_talwar — Thu, 04 May 2017 11:44:57 GMT

Error while reloading or when you used in your expression?

Re: Putting a Set Analysis Expression into a Variable

Anonymous — Thu, 04 May 2017 11:55:50 GMT

I'm displaying the expression in a text object. When I reload, the text object displays that error message instead of the expression.

Re: Putting a Set Analysis Expression into a Variable

sunny_talwar — Thu, 04 May 2017 13:05:39 GMT

can you see what the variable definition is after the reload is completed in the variable overview? Can you share an image of variable overview?

Re: Putting a Set Analysis Expression into a Variable

Anonymous — Thu, 04 May 2017 13:41:53 GMT

Variable Overview shows this value for vSubSelectColor1 after a reload:

ONLY({<CompName={""} >} CompColor)

With your changes, after a reload, I get a script line error on the line, and Variable Overview shows this:

ONLY({<KeyValue={"$(=TRIM(SUBFIELD(GetFieldSelections($(vFieldName)),

I tried replacing the single quotes with chr(39), and Variable Overview shows this:

ONLY({<KeyValue={"$(=TRIM(SUBFIELD(GetFieldSelections($(vFieldName)),',',1)))"} >} KeyColor)

think I've got it figured out - I ALSO had to break the variable declaration up as you indicated on vColor1, like so:

LET vDimColor1 = 'IF($' & '(vSelectAllOrNone), KeyColor1, $' & '(vSubSelectColor1))';

Now, for the calculated color, the expression consists of this:

=$(vDimColor1)

After FOUR full days of work, it finally seems to work as intended.