Fine in text box, garbage when in expression

JustinDallas — Wed, 06 May 2015 13:52:31 GMT

Hello Everyone,

So I've got a piece of title creation logic that appears quite a bit in my application

=IF( SubStringCount( GetFieldSelections(TerritoryDistrict ,'|'), 'ALL'),'North America',
  IF( SubStringCount( GetFieldSelections(TerritoryDistrict ,'|'), 'NOT District 7') , 'US',
  IF( SubStringCount( GetFieldSelections(TerritoryDistrict ,'|'), 'NOT Agricultural|District 7') , 'US Less Ag',
  GetFieldSelections(TerritoryDistrict ,','))
  ))

When I put this into a Text Object as the text, it evaluates fine. However, when I put this expression into a variable, and then tell a text box to show that, I get "Garbage after expression: "Less"". What am I doing wrong where it isn't getting parsed correctly in my TextObject? I've attached an image of the offending characters.

Any help on this matter is greatly appreciated.

Re: Fine in text box, garbage when in expression

Gysbert_Wassenaar — Wed, 06 May 2015 14:12:56 GMT

That's something weird about dollar expanding variables that return strings. If you try =vTerritoryReadable you should get a result.

topic Fine in text box, garbage when in expression in QlikView

Fine in text box, garbage when in expression

Re: Fine in text box, garbage when in expression