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

[Anonymous]

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

[kaushiknsolanki · Accepted solution]

Hi,

Add the calculated dimension as below.

If(ColumnName = 1,'Dropped',

If(ColumnName = 2,'Collected',

If(ColumnName = 3, 'Banked')))

Regards,

Kaushik Solanki

[woshua5550]

you'd better create a mapping table like this

then you can use "Action"  as your dimension

[Anonymous]

Hi Kaushik.

Thank you so much.. I will give it a bash and see if it works.

Regards

Gerhard.

[Anonymous]

Works like a charm!