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: 
Anonymous
Not applicable

I am new to qlikview. Kindly guide to achieve my requirement

I have a requirement.

I have a column with integer values 1 and 2. I want to display them in a list box with Strring values like 'Incoming' for 2 and 'Outgoing' for 1.  How can i achieve this.

Thanks a lot in advance!!!

1 Reply
sunny_talwar

May be create a new field in the script like this

LOAD Field,

     Pick(Field, 'Outgoing', 'Incoming') as Field_Desc

FROM ....