Can you have a field with more than one value

[Anonymous]

Is it possible to have a field e.g. Disability that captures more than one disability for a particular customer.  If a customer is both blind and deaf can this be captured in a single field?

[JonnyPoole]

If your data is in the format then yes. Usually data that has multiple values stored in a single field has a delimiter like a comma

etc...   

Row     Regions

1          America, Europe, Asia

2          America,Asia

etc...  

you can use the subfield(Regions,',') function to pass a delimitted field with the delimitter  to normalize the values into a table helpful for analysis. This allows you see all the rows with 'America' IN the value rather than having to check all the possible combinations in which America exists embedded within a string of values.

Row     Region

1          America

1          Europe

1          Asia

2          America

2           Asia

[veidlburkhard]

Yes, Greg, why not?

in your raw data you have e.g. an Excel table like this:

Disability

blind

deaf

blind & deaf

You can load this into QlikView and if you want you can separate it with the SubField function.

Hope this helps

Burkhard

[Gysbert_Wassenaar]

Sure

Disabilities:

LOAD * INLINE [

Customer, Disabilities

A, Blind

B, Blind and Deaf

C, Mute

];

You could also use bit values:

1 = blind

2 = deaf

4 = mute

Then a value of 3 would mean blind and deaf

But what you really should do is simply add a record for each disablitiy:

LOAD * INLINE [

Customer, Disability

A, Blind

B, Blind

B, Deaf

C, Mute

];