4 Replies Latest reply: Oct 24, 2017 6:30 AM by Gerhard Lourens RSS

    how to seperate data in an excel column for display in Qlik

    Gerhard Lourens

      Good day all..

       

      I have a basic question that i just can't seem to get right.

      I have a column with numerical values 1, 2, 3 etc. however that value represents an action. where 1 = Dropped, 2 = collected and 5 = Banked.

      how do i change in a pivot the row which is numerical to display the word?

       

      regards

      Gerhard