Discussion board where members can learn more about Qlik Sense App Development and Usage.
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?
Go to Solution.
Add the calculated dimension as below.
If(ColumnName = 1,'Dropped',
If(ColumnName = 2,'Collected',
If(ColumnName = 3, 'Banked')))
you'd better create a mapping table like this
then you can use "Action" as your dimension
Thank you so much.. I will give it a bash and see if it works.
Works like a charm!