Group fields with head start name

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

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:

HB1010X002Y01Z12

HB1010X002Y01Z21

HB1010X002Y01Z22

HB2020X002Y03Z21

HB2020X002Y03Z22

HB2020X002Y04Z21

I want them to be grouped up to HB1010. Because the location names have a starting name with HB1010X002Y02Z21
Same as HB2020 etc.

Any expressions to think about?

Re: Group fields with head start name

sunny_talwar — Tue, 31 Oct 2017 14:08:29 GMT

Create a new field like this

Left(FieldName, 6) as LocationName,

FieldName

Now, if you will select HB1010 in LocationName, it will select all those FieldName, where the first 6 are HB1010

topic Re: Group fields with head start name in QlikView

Group fields with head start name

Re: Group fields with head start name