This content has been marked as final.
Show 4 replies
-
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
-
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.
-
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!
-
-