Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 (2)
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