Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
arngue
Contributor III
Contributor III

Why subfield chart funciton only returns first value

I have a variable like

vUnits = 'aaaa-bbbb-cccc-dddd-eeee-ffff'

 

When in a straight table (graphic chart) i put Subfield(vUnits,'-'). Why only shows first row 'aaaa'?

 

Is there anything i'm doing wrong or this can't be acomplished? I need it in a different rows.

 

Can i do any type of for each in here? because Subfield(vUnits,'-',2) returns 'bbbb'.

 

I cannot load as a subfield because its a generated value from a button in qvw.

Labels (1)
11 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

That particular pattern of doubled up quotes seems to work only in Nov 2017 onwards.   I thought we were done with chr(39). Sigh.

-Rob

arngue
Contributor III
Contributor III
Author


@dplr-rn wrote:

Did you try Subfield(vUnits,'-', rowno())


Did not work