facing problem with List box

[#1]

Hi ...I have  a list box(please find the below attachment) , that is having data like Out Of Warranty and Out of Warranty (because of upper and lower cases present).., but those two are same only ,now i need to show only one Out Of Warranty in my qlikview report...how can get this, is it possible?

Regards,

Sh.

[Gysbert_Wassenaar]

If they show up in the listbox then they are unique values and not the same. If you are of the opinion that the are duplicates then you need to replace them in the script with the exact same value. You can use the trim function to remove trailing spaces. You can use the Capitalize, Lower and Upper functions to change the case of the values.

[#3]

Hi, You can use mapping too.