Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

g_lourens
New Contributor

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

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

1 Solution

Accepted Solutions

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

Hi,

Add the calculated dimension as below.

If(ColumnName = 1,'Dropped',

If(ColumnName = 2,'Collected',

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

Regards,

Kaushik Solanki

4 Replies

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

Hi,

Add the calculated dimension as below.

If(ColumnName = 1,'Dropped',

If(ColumnName = 2,'Collected',

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

Regards,

Kaushik Solanki

woshua5550
Contributor III

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

you'd better create a mapping table like this

微信截图_20171024153230.png

then you can use "Action"  as your dimension

g_lourens
New Contributor

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

Hi Kaushik.

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

Regards

Gerhard.

g_lourens
New Contributor

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

Works like a charm!