Expansion with SubField creating error in If Statement

Jagsfan82 — Sat, 16 Nov 2024 03:13:41 GMT

My If statement feels like it should be pretty simple, but my second SubField expansion is breaking the expression, and I'm assuming this is because I'm using $(=) instead of $(), but I'm not sure how else to pull in the expansion.

If(GetSelectedCount(%vsExprR.Favorites)>0,$(=SubField(Concat(%vsExprR.Expansion,'|'),'|',1)), //Any Selections for Right Axis If(GetSelectedCount(%vsExprL.Favorites)>1,$(=SubField(Concat(%vsExprL.Expansion,'|'),'|',2)), //More than Two Selections for Left $(mPolicyCount))) //Anything Else

Essentially this code is for the expression portion of a list box. There are right and left list boxes. The list boxes changes based on user selections. They select a field they want to analyze and then they can choose a "Left" expression(s) and/or a "Right" expression(s). The ExprL table has expression names in one field and dollar sign expansions in another. These expansions correlate with expressions I already have stored as variables. So when the user selects "Sum of Premium" this would link to $(vSumPremium), which is what I would want to use as the expression.

This works fine except when only one value is selected for the ExprL.Favorites, this means only one value for ExprL.Expansion is available, so evaluating for SubField number 2 creates an error in my expression. It shows up as "-" in the list box, and when thrown into a text box returns "Error: Error in expression: ')' expected".

I solved this by choosing the '2' in the second SubField to '-1', but would there be a way to get this to work while still pulling the second SubField? Picture Below

Re: Expansion with SubField creating error in If Statement

SergeyMak — Fri, 21 Jun 2019 05:20:25 GMT

Hi!

I'd suggest you to share an example app.

Another thing is to try to evaluate the expressions in text boxes separately: eg

SubField(Concat(%vsExprR.Expansion,'|'),'|',1)

for one

and

SubField(Concat(%vsExprL.Expansion,'|'),'|',2)

for another.

It might help you to understand what exactly is happening, when you make your selections

topic Re: Expansion with SubField creating error in If Statement in QlikView

Expansion with SubField creating error in If Statement

Re: Expansion with SubField creating error in If Statement