Remove first selected value in chart expression

[#1]

Dear Experts

Help me removing first row in chart flat table  and chart expression. Need to remove MTTF 104 from chart table.

Following expression is used to obtain below result.

=ceil(fabs(sum({<Plant={$(vWERKS)}>}if(Date(EQM_AUSVN,'M/D/YYYY') >=v_YTM_MONTH and Date(EQM_AUSVN,'D/M/YYYY')<=(v_FTM_DATE),MTBF ))

/Count({<Plant={$(vWERKS)}>}if(Date(EQM_AUSVN,'D/M/YYYY') >=v_YTM_MONTH and Date(EQM_AUSVN,'D/M/YYYY')<=(v_FTM_DATE),if(EQM_MSAUS='X',EQM_QMNUM)))))

Thanks

Ashif

[anbu1984]

=If(RowNo() >1 , your_expression)

[saumyashah90]

1)You will have to change the dimension and not expression for that.

for example:

if(Date([Start Days],'DD/MM/YYYY')>'01/12/2013',CLASS)

2)Or lese if you have RowNo then
=if(RowNo()>1,Expression)

[#4]

Thanks,

It not working can you suggest other ways.

Ashif

[saumyashah90]

Can you please attach the qvw?

[#6]

I can post the all data.

CLASS	Equipment	Start Date	End Date	MTTF(Days)
Chis-Transit Mxr 6	993	23/02/2014	23/02/2014	131
Chis-Transit Mxr 6	993	14/05/2014	28/05/2014	80
Chis-Transit Mxr 6	994	20/10/2013	25/10/2013	5
Chis-Transit Mxr 6	994	20/10/2013	25/10/2013	22
Chis-Transit Mxr 6	994	28/10/2013	29/10/2013	3
Chis-Transit Mxr 6	994	27/11/2013	28/11/2013	29
Chis-Transit Mxr 6	994	20/01/2014	21/01/2014	53
Chis-Transit Mxr 6	995	25/11/2013	25/11/2013	62
Chis-Transit Mxr 6	997	01/12/2013	02/12/2013	104
Chis-Transit Mxr 6	997	20/01/2014	21/01/2014	49
Chis-Transit Mxr 6	997	05/03/2014	07/03/2014	43
Chis-Transit Mxr 6	1018	23/10/2013	26/10/2013	11
Chis-Transit Mxr 6	1018	29/11/2013	02/12/2013	34
Chis-Transit Mxr 6	1385	27/10/2013	28/10/2013	1
Chis-Transit Mxr 6	1385	27/10/2013	28/10/2013	866
Chis-Transit Mxr 6	1385	10/04/2014	10/04/2014	164
Chis-Transit Mxr 6	7773	06/10/2013	06/10/2013	12
Chis-Transit Mxr 6	7773	18/10/2013	18/10/2013	12
Chis-Transit Mxr 6	7773	20/10/2013	20/10/2013	2
Chis-Transit Mxr 6	7773	22/10/2013	22/10/2013	2
Chis-Transit Mxr 6	7773	01/11/2013	01/11/2013	10
Chis-Transit Mxr 6	7773	08/04/2014	08/04/2014	158
Chis-Transit Mxr 6	9129	06/10/2013	06/10/2013	499
Chis-Transit Mxr 6	9129	16/11/2013	29/11/2013	67
Chis-Transit Mxr 6	9129	08/02/2014	09/02/2014	71

[saumyashah90]

Hi this will surely help you

[#8]

HI Saumya

I think we're wrongly interpret the problem. I don't just want first record to remove from just first row of table but for each equipment.

Regards

Ashif

[saumyashah90]

there is a way to do that also

[#10]

How?