how to remove unwanted data from a field??

[sushil353]

Hi All,

I have a field named Defect_type in which many type of defects are listed, but i need to take only two type of defect say NDR and NDF

I want to display only NDR and NDF in Defect_type field and all other defects should not affect my charts and reports.....

Suppose i have a chart to show unit processed according to NDR or NDF then the unit processed should be for NDR or NDF only not for other....

It should be just like i have only two type of defect_type NDR and NDF

please help me out....

Thanks

[#2]

Hi,

you can make a selection in the script by using a where clause:

where match(Defect_type, 'NDR','NDF')>0

Regards,

Björn

[#3]

Hi, a simple way could be to create a INLINE table with 2 fields like this

LOAD

* INLINE [
Defect_type, My_Defect_type
NDR,NDR

NDF,NDF

and use My_Defect_type as dimension.

[sushil353]

hi Bjorn

I have already loaded the data...i think your solution works during loading...

[#5]

Hi,

yes my suggestion works while loading.

If you only want to do it in a chart you can try the solution mentioned by hakanbjerke or you make a set analyis in the chart expression:

sum({<Defect_type={'NDR','NDF'}>}value)

Regards,

Björn

[#6 · Accepted solution]

On any Chart,

go to Used dimension. Select the 'Defect_type' field dimension and Click on 'Edit'. There you type the following if condition:

=if(Defect_type='NDR' of Defect_type='NDF',Defect_type).

And finally, select 'Supress When Value is Null' on the 'Setting for Selected Dimensions' area.

Regards.