topic Re: Merging two fields with values in QlikView

Merging two fields with values

Anonymous — Sun, 16 Oct 2016 06:26:01 GMT

Hi All,

I have two columns in my Table Diverse. it looks like following:

Gender(US) and Gender(UK).

Gender(US) has value 0,blank and Female. Gender(UK) have values 0, blank, X, WBE and Female.

What I want to do is make a single field GENDER having values of Gender(UK) as it has even the values of Gender(US) ,but on selection it should give me both the records of Gender(UK) and Gender(US).

Any help would be appreciated.

Thanks.

Re: Merging two fields with values

MarcoWedel — Sun, 16 Oct 2016 21:51:29 GMT

can you post an example of the results of some selections.

thanks

regards

Marco

Re: Merging two fields with values

Anonymous — Mon, 17 Oct 2016 06:16:49 GMT

Hi marco,

That won't be possible but i think i explained the complete thing above.

Gender(US) have values:

blank

Female

Gender(UK) have values:

blank

Female

WBE

I want a final field with values:

blank

female

WBE

and on selection i should be able to get the records for both Gender(US) and Gender(UK).

Thanks.

Re: Merging two fields with values

adamdavi3s — Mon, 17 Oct 2016 06:27:36 GMT

Why not split it into two

Gender, Country

Then you can simply use set analysis or filters to work out your expressions, something along the lines of:

LOAD 'UK' as country, Gender(UK) as Gender

RESIDENT fact

WHERE Gender(UK) >0;

CONCATENATE

LOAD 'US' as country, Gender(US) as Gender

RESIDENT fact

WHERE Gender(US) >0;

And then something like

count({<Gender={'x'}>}Gender) as gender_x

count({<Gender={'x'},country={'UK'}>}Gender) as gender_x_uk

etc

Please remember to mark this answer as helpful or correct if it is.

Re: Merging two fields with values

Anonymous — Mon, 17 Oct 2016 06:43:19 GMT

Hey Adam,

This is complicating the things. Moreover it is just not this one field, there are in total 23 fields like this which i need to merge.

Any other suggestions would be really helpful.

Thanks

Re: Merging two fields with values

Anonymous — Mon, 17 Oct 2016 07:18:32 GMT

Hi,

Try a crosstable.. see attached..

Hopefully this helps you!

Re: Merging two fields with values

Aurelien_Martinez — Mon, 17 Oct 2016 13:14:38 GMT

Hi,

you can use crosstable

CrossTable(Country, gender)
LOAD * INLINE [
  id, genderUS, genderUK
  1, F, W
  2, 0, 1
];

Aurélien

Consultant Excelcio

Re: Merging two fields with values

MarcoWedel — Mon, 17 Oct 2016 23:30:15 GMT

I guess the already suggested crosstable solution should serve you best, particularly with many source fields.

regards

Marco