exclude value

[raadwiptec]

hi all,

I have a scenarie where I display the data based on few id and year

for eg:

id ¦ yearmm

1 ¦ 201501

2!201502

3!201503

4!201504

5!2015 05

now I would like to add id =6 but it should diplay values only starting from yearmm- 201205 ..even though if it has data from past months

[avinashelite]

try like this

if(yearmm>'201205',id)

[raadwiptec]

hi avinash

I only need to do this for id =6 rest of them it should show as usual all the previous months

[avinashelite]

i did not get you, can you please elaborate bit more with the output your excepting 

[Kushal_Chawda]

try,

Data:

load id,

yearmm

if( id=6 and yearmm>=201505,1,if(id<>6 ,0) ) as FlagId6

From Table;

Final:

noconcatenate

load *

resident Data

where FlagId6=0;

concatenate(Final)

load *

resident Data

where FlagId6=1;

drop table Data;

[raajaswin]

I think this will work

=pick(match(id,'6')+1,if(yearmm>'201205',yearmm,'year mm condition fails'),yearmm)