topic Re: Remove first selected value in chart expression in QlikView

Remove first selected value in chart expression

Wed, 17 Dec 2014 06:37:23 GMT

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

Re: Remove first selected value in chart expression

anbu1984 — Wed, 17 Dec 2014 06:44:16 GMT

=If(RowNo() >1 , your_expression)

Re: Remove first selected value in chart expression

saumyashah90 — Wed, 17 Dec 2014 06:46:18 GMT

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)

Re: Remove first selected value in chart expression

Wed, 17 Dec 2014 07:06:03 GMT

Thanks,

It not working can you suggest other ways.

Ashif

Re: Remove first selected value in chart expression

saumyashah90 — Wed, 17 Dec 2014 07:07:37 GMT

Can you please attach the qvw?

Re: Remove first selected value in chart expression

Wed, 17 Dec 2014 08:06:52 GMT

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

Re: Remove first selected value in chart expression

saumyashah90 — Wed, 17 Dec 2014 08:35:52 GMT

Hi this will surely help you

Re: Remove first selected value in chart expression

Wed, 17 Dec 2014 08:50:45 GMT

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

Re: Remove first selected value in chart expression

saumyashah90 — Wed, 17 Dec 2014 11:11:00 GMT

there is a way to do that also

Re: Remove first selected value in chart expression

Wed, 17 Dec 2014 11:40:52 GMT

How?

Re: Remove first selected value in chart expression

tresB — Wed, 17 Dec 2014 12:06:14 GMT

Front-end? Try expression like:

If(Above(total Equipment)=Equipment,[MTTF(Days)])

The similar could be done in script as well.

Note: here sort order and aggregation matter.

PFA

Re: Remove first selected value in chart expression

Anonymous — Wed, 17 Dec 2014 12:24:07 GMT

Hi Ashif,

I managed to get a table working using the following expression

=Sum(Aggr(If(IsNull(Above(Sum(MTTF))),0,Sum(MTTF)),Equipment, Date))

Then ignoring zero values in my chart. Not sure if this is what you are looking for and it will probably need more development but it might help you.