2 Replies Latest reply: Aug 9, 2017 10:26 AM by Andrea Gigliotti RSS

    Merging columns in pivot table

    Léa Couturier

      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.