topic RE:selection in QlikView

RE:selection

Chanty4u — Wed, 15 Jul 2015 15:41:49 GMT

hi guys

need help

i have address and i want to pic state city frm that adress as a field for that wat cn i do?

thanks

Re: RE:selection

sunny_talwar — Wed, 15 Jul 2015 15:45:15 GMT

Can you provide sample? Also are you trying to do this in the front end or script??

Re: RE:selection

maxgro — Wed, 15 Jul 2015 15:45:20 GMT

you can post some example

or you can look at string functions (subfield, left, right, mid, index) in the help; I suppose you have some delimiter you can use to split the address in city, etc....

Re: RE:selection

sinanozdemir — Wed, 15 Jul 2015 15:47:38 GMT

Following @maxgro‌'s suggestion, you can use Subfield as shown below:

Re: RE:selection

Chanty4u — Wed, 15 Jul 2015 15:57:59 GMT

Tanq sinan,

Actually data in server sry fr am nt attchng the file.

in abve example u want to look for PA address then how would you do..?

thanks.

Re: RE:selection

sinanozdemir — Wed, 15 Jul 2015 16:05:02 GMT

I use Where clause in another preceding load statement: