topic Re: Why subfield chart funciton only returns first value in QlikView

Why subfield chart funciton only returns first value

arngue — Sat, 16 Nov 2024 04:43:41 GMT

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.

Re: Why subfield chart funciton only returns first value

sunny_talwar — Thu, 17 Jan 2019 17:15:53 GMT

What exactly do you want it to do? Show all values in different rows?

Re: Why subfield chart funciton only returns first value

arngue — Thu, 17 Jan 2019 17:19:42 GMT

Exactly, in a different rows!!

Re: Why subfield chart funciton only returns first value

sunny_talwar — Thu, 17 Jan 2019 17:21:37 GMT

I don't think you would be able to do this on the front end of the app. AFAIK you will have to create a new field in the script and then use that.

Re: Why subfield chart funciton only returns first value

arngue — Thu, 17 Jan 2019 17:24:49 GMT

Thank you, for your fast reply, I'll catch another solution, bit tricky, but will also work:

I gonna just do a couple of Text chart and put Replace(vUnit,'-','\n\n') and this would emulate a table.

Re: Why subfield chart funciton only returns first value

dplr-rn — Thu, 17 Jan 2019 17:46:01 GMT

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

Re: Why subfield chart funciton only returns first value

rwunderlich — Thu, 17 Jan 2019 17:51:09 GMT

I think:

=ValueList($(='''' & replace('$(vUnits)','-', ''',''') & ''''))

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Why subfield chart funciton only returns first value

sunny_talwar — Thu, 17 Jan 2019 17:59:23 GMT

Not sure why, but Rob it did not work for me using single quotes within single quotes. I had to use Chr(39) and then it worked.

=ValueList($(=Chr(39) & Replace(vUnits, '-', Chr(39)&','&Chr(39)) & Chr(39)))

Re: Why subfield chart funciton only returns first value

rwunderlich — Thu, 17 Jan 2019 21:19:27 GMT

Sunny, which version?

Re: Why subfield chart funciton only returns first value

sunny_talwar — Fri, 18 Jan 2019 12:13:52 GMT

QV 12.1 SR2

Re: Why subfield chart funciton only returns first value

rwunderlich — Fri, 18 Jan 2019 15:02:06 GMT

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

Re: Why subfield chart funciton only returns first value

arngue — Tue, 22 Jan 2019 09:05:10 GMT

@dplr-rn wrote:
Did you try Subfield(vUnits,'-', rowno())

Did not work