topic spliting array in QlikView

spliting array

Fri, 18 Feb 2011 11:47:01 GMT

how to split a string through a word/character and assign it into a variable

ex string 1000 , 1234 , 1234 ,

I want to assign this string into a variable and then split it trough ' comma

how to do this through macro

tresB — Fri, 18 Feb 2011 11:56:08 GMT

Hi,

Use Subfield(). Like Subfield('YourString', ' , ')

Regards, tresesco

Fri, 18 Feb 2011 12:09:02 GMT

But I wnat to use macro

Fri, 18 Feb 2011 12:09:42 GMT

but I have to use macro

prieper — Fri, 18 Feb 2011 12:19:42 GMT

Check this Fred:

http://community.qlik.com/forums/p/16444/64153.aspx

HTH
Peter