Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
JustinDallas
Valued Contributor II

Fine in text box, garbage when in expression

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.

QlikTextIssue.PNG

QlikTextIssue2.PNG

Any help on this matter is greatly appreciated.

Tags (2)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Fine in text box, garbage when in expression

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


talk is cheap, supply exceeds demand
1 Reply
MVP & Luminary
MVP & Luminary

Re: Fine in text box, garbage when in expression

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


talk is cheap, supply exceeds demand