need urgent reply

[#1]

Hi ...I have  a list box(please find the below attachment) , that is having data like Out Of Warranty and Out of Warranty.., 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.

[jpapador]

In the load script use a replace command.

Replace(Name Of Field, 'Out Of Warranty', 'Out of Warranty') as Name of Field

[omyahamburg]

Hi

Write in script

if(PPS_ES_Type='Out of Warranty','Out Of Warranty',PPS_ES_Type) as PPS_ES_Type;

or write

capitalize(PPS_ES_Type) as PPS_ES_Type;

regards

Joerg