topic need urgent reply in QlikView

need urgent reply

Tue, 09 Jul 2013 14:00:22 GMT

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.

Re: need urgent reply

jpapador — Tue, 09 Jul 2013 14:13:20 GMT

In the load script use a replace command.

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

Re: need urgent reply

omyahamburg — Tue, 09 Jul 2013 14:14:56 GMT

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