Discussion Board for collaboration on QlikView Layout & Visualizations.
i have address and i want to pic state city frm that adress as a field for that wat cn i do?
Can you provide sample? Also are you trying to do this in the front end or script??
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....
Following @maxgro's suggestion, you can use Subfield as shown below:
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..?
I use Where clause in another preceding load statement: