topic facing problem with List box in QlikView

facing problem with List box

Tue, 09 Jul 2013 14:12:38 GMT

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.

Re: facing problem with List box

Gysbert_Wassenaar — Tue, 09 Jul 2013 14:24:01 GMT

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.

Re: facing problem with List box

Tue, 09 Jul 2013 17:14:43 GMT

Hi, You can use mapping too.