Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Merging columns in pivot table

Hi,

When I try to load a column supposed to show the gender of various people in a pivot table, Qlik Sense automatically divides it in two different columns, one for each gender (in the .csv file everything is in the same column).

pb.jpg

I'd like to merge those columns to create a unique one with words and not numbers, like this :

GENDER

Woman

Man

Man

...

How could I do this ? Let me know if more details are needed.

2 Replies
rittermd
Honored Contributor

Re: Merging columns in pivot table

If Gender was a row and not a column then I think that you would get what you want.

agigliotti
Honored Contributor II

Re: Merging columns in pivot table

you should set GENDER dimension as row rather than column.

Community Browser