Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
new2qlik
Contributor III
Contributor III

Rename value in espression editor

I'm trying to name some value. The value comes out as 1, 2, 3. I want to rename it to drop ship, warehouse order etc.

It does not seem to work.

=if(OrderType='1', Warehouse order,
if(OrderType='2', Direct Ship order,OrderType))

 

Attachment included.

3 Replies
rbartley
Specialist II
Specialist II

Have you tried enclosing the text in single quotes? e.g. 

=if(OrderType='1', 'Warehouse order',
if(OrderType='2', 'Direct Ship order',OrderType))

new2qlik
Contributor III
Contributor III
Author

That was it. So simple.

 

Thank you!!!!!!

rbartley
Specialist II
Specialist II

Ok, no problem.  Could you please mark the reply as correct so that others don't try to answer this?