Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sureshqv
Esteemed Contributor III

RE:selection

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

5 Replies

Re: RE:selection

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

MVP
MVP

Re: RE:selection

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....

sinanozdemir
Valued Contributor III

Re: RE:selection

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

Capture.PNG

Capture2.PNG

sureshqv
Esteemed Contributor III

Re: RE:selection

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.

sinanozdemir
Valued Contributor III

Re: RE:selection

I use Where clause in another preceding load statement:

Capture.PNG

Capture2.PNG

Community Browser