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

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

Gerhard Lourens Oct 24, 2017 3:07 AM

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

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

Kaushik Solanki Oct 24, 2017 3:13 AM (in response to Gerhard Lourens)

Hi,

Add the calculated dimension as below.

If(ColumnName = 1,'Dropped',
If(ColumnName = 2,'Collected',
If(ColumnName = 3, 'Banked')))

Regards,
Kaushik Solanki
Like Show 0 Likes (0)

Actions
- Re: how to seperate data in an excel column for display in Qlik
  
  Gerhard Lourens Oct 24, 2017 4:00 AM (in response to Kaushik Solanki )
  
  Hi Kaushik.
  
  Thank you so much.. I will give it a bash and see if it works.
  
  Regards
  Gerhard.
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: how to seperate data in an excel column for display in Qlik
    
    Gerhard Lourens Oct 24, 2017 6:30 AM (in response to Gerhard Lourens)
    
    Works like a charm!
    
    Like Show 0 Likes (0)
    
    Actions
Re: how to seperate data in an excel column for display in Qlik

dave liu Oct 24, 2017 3:35 AM (in response to Gerhard Lourens)

you'd better create a mapping table like this
then you can use "Action" as your dimension
Like Show 0 Likes (0)

Actions