So.…….. we have a lot of data fields, what I want to do is map the number or opportunities by PostCode Area.
So, I have the post code in full, I only want the first half of the postcode ……. so is there a way to get Qlik to narrow that down?
Then I want it to go and count the number of unique opportunities and colour in the PostCode Area
But I also need to be able to filter those postcodes down as I am only interested in 2 areas of the UK not the entire island
I hope this makes sense but I really am struggling and I have been asked to show some kind of visualisation. I have tried on Esri but cannot manually colour in the Postcode areas or I would have done it that way