Discussion board where members can get started with QlikView.
Sorry if I'm a bit unclear. I try to put together different names together to one and can pick everything thereafter. I don't actually know how to think or how to do it.
Let us say I have those names:
I want them to be grouped up to HB1010. Because the location names have a starting name with HB1010X002Y02Z21Same as HB2020 etc.
Any expressions to think about?
Create a new field like this
Left(FieldName, 6) as LocationName,
Now, if you will select HB1010 in LocationName, it will select all those FieldName, where the first 6 are HB1010