how to mask data in qlikview

[#1]

Hi Friends,

Hope this is a simple requirement , I'm new to Qlikview

I have a list box , and in that 2 values are populating.Those are numerical values (42, 43 ), I need to mask to Accept and Reject.

42= Accept

43=Reject

Is there any way to give alias names in Qlikview? Please see the attached screen shot ?

[danansell42]

You could change the field in the script.

If(FieldName = 42,'Accept'.if(FieldName= 43,'Reject','Other')) as FieldName

Thanks

Dan

[danansell42]

Should also mention you could do it within the list box itself.

Instead of selecting the field select 'Expression'

Then add the same formula.

I also noticed in your screenshot the numbers are 42 and 45 so formula will need amending to reflect the numbers.

Dan

[sunny_talwar]

You can also try this with Pick(Match(...)) function...

Pick(Match(Status, 42, 45), 'Accept', 'Reject') as Status

[#5]

Thanks ,

Dan and Sunny its working fine.

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .