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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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