Discussion Board for collaboration related to QlikView App Development.
I know am a pain but please bear with me.
what i am trying to achieve is to get the first two letters of a post code in a city and then i want to create an analysis of post codes where accident is more frequent.
below is the address table; what i want is get the first two letters in the postcode then i can use Towncity as a dimension and can drill through the post code, i dont know if am making sense.. any idea will be appreciated
the 2 leter alwways be first???
if yes you can do left(Postcode,2) as letter_poscode
If the letter are for anywuere you can use
purgechar ( 'a1b2c3','123' ) return 'abc' ..
purgechar ( 'Postcode','1234567890' ) as letter_poscode
Hope that gelps you
Hello, basically this is what i need, i can do it on sql but how do i update it in the address table i have in the folder.
I want to add this line of code to the address table but how can i do it. You guys rock
CASE (isnumeric(SUBSTRING([Postcode] , 2 , 1))) WHEN 1 THEN LEFT ([Postcode] , 1) ELSE LEFT ([Postcode] , 2) END as PostcodeLetters