Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)))
What exactly do you want it to do? Show all values in different rows?
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.
Did you try Subfield(vUnits,'-', rowno())
I think:
=ValueList($(='''' & replace('$(vUnits)','-', ''',''') & ''''))
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
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)))
Sunny, which version?
QV 12.1 SR2