topic Re: show max from group in graph table in QlikView

show max from group in graph table

rafael5958 — Fri, 13 Mar 2020 17:57:37 GMT

I have a graphic table as this

reqSIT/ID	reqOper/ID	encamReq/NOME_OPER	encamReq/DATA	result/DATA_FIM_CARGA	result/TIPO_RESULTADO	tempo Resp ( D HH:mm:ss)
						411:16:05
3008	43008	MMMMM	12/09/2016 10:52:24	07/10/2016 14:44:58	P	603:51:41
3008	43008	MMMMM	12/09/2016 10:52:24	11/10/2016 18:29:15	P	703:36:27
3009	43009	MMMMM	12/09/2016 10:52:25	07/10/2016 14:45:10	P	603:51:41
3010	43010	MMMMM	12/09/2016 10:52:25	07/10/2016 14:45:39	P	603:51:42
3011	43011	MMMMM	12/09/2016 10:52:25	07/10/2016 14:44:02	N	603:51:37
3012	43012	MMMMM	12/09/2016 10:52:25	07/10/2016 14:45:31	P	603:51:42
3013	43013	MMMMM	12/09/2016 10:52:25	07/10/2016 14:45:22	P	603:51:41
3014	43014	MMMMM	12/09/2016 10:52:26	07/10/2016 14:44:05	N	603:51:37
3015	43015	MMMMM	12/09/2016 10:52:26	07/10/2016 14:44:03	N	603:51:37

The first two rows show same values, only difference is in result/DATA_FIM_CARGA. I must show only the higher result/DATA_FIM_CARGA. How can i do that?

Should be:

reqSIT/ID	reqOper/ID	encamReq/NOME_OPER	encamReq/DATA	result/DATA_FIM_CARGA	result/TIPO_RESULTADO	tempo Resp ( D HH:mm:ss)
						411:16:05
3008	43008	MMMMM	12/09/2016 10:52:24	11/10/2016 18:29:15	P	703:36:27
3009	43009	MMMMM	12/09/2016 10:52:25	07/10/2016 14:45:10	P	603:51:41
3010	43010	MMMMM	12/09/2016 10:52:25	07/10/2016 14:45:39	P	603:51:42
3011	43011	MMMMM	12/09/2016 10:52:25	07/10/2016 14:44:02	N	603:51:37
3012	43012	MMMMM	12/09/2016 10:52:25	07/10/2016 14:45:31	P	603:51:42
3013	43013	MMMMM	12/09/2016 10:52:25	07/10/2016 14:45:22	P	603:51:41
3014	43014	MMMMM	12/09/2016 10:52:26	07/10/2016 14:44:05	N	603:51:37
3015	43015	MMMMM	12/09/2016 10:52:26	07/10/2016 14:44:03	N	603:51:37

Re: show max from group in graph table

rafael5958 — Mon, 16 Mar 2020 12:18:42 GMT

If I use:

if((Max(aggr(max([result/ID]), [reqOper/ID])))-[reqOper/ID]=0,[result/ID],(Max(aggr(max([result/ID]), [reqOper/ID]))))

It shows me :

reqSIT/ID	reqOper/ID	encamReq/NOME_OPERADORA	encamReq/DATA	result/DATA_FIM_CARGA	result/DATA_RECEBIMENTO	result/TIPO_RESULTADO	result/ID	tempo Resp ( Dias HH:mm:ss)	//if(Max(aggr(Sum([result/ID]), [reqOper/ID]))=null(),null(),[reqOper/ID]) //Max(aggr(max([result/ID]), [reqOper/ID])) //if([result/ID]= Max(aggr(Sum([result/ID]), [reqOper/ID] )), [result/ID], '0' ) if((Max(aggr(max([result/ID]), [reqOper/ID])))-[reqOper/ID]=0,[result/ID],(Max(aggr(max([result/ID]), [reqOper/ID]))))
								337:20:58
1562	41562	MMM	19/01/2016 13:49:10	22/01/2016 11:46:09	22/01/2016 11:45:09	N	47502971	69:55:59	47698783
1562	41562	MMM	19/01/2016 13:49:10	05/02/2016 18:15:18	05/02/2016 18:15:10	N	47698763	412:26:00	-
1562	41562	MMM	19/01/2016 13:49:10	10/02/2016 15:40:54	10/02/2016 15:30:06	P	47698783	529:40:56	-

But still shows and count the null cell, I dont want it, I want to remove it, is there a way?

Re: show max from group in graph table

Saravanan_Desingh — Fri, 15 May 2020 01:12:02 GMT

One solution through Script..

tab1: LOAD "reqSIT/ID", "reqOper/ID", "encamReq/NOME_OPER", "encamReq/DATA", Timestamp#("result/DATA_FIM_CARGA",'MM/DD/YYYY hh:mm:ss') As "result/DATA_FIM_CARGA", "result/TIPO_RESULTADO", "tempo Resp ( D HH:mm:ss)" ; LOAD * INLINE [ "reqSIT/ID", "reqOper/ID", "encamReq/NOME_OPER", "encamReq/DATA", "result/DATA_FIM_CARGA", "result/TIPO_RESULTADO", "tempo Resp ( D HH:mm:ss)" , , , , , , 411:16:05 3008, 43008, MMMMM, 12/09/2016 10:52:24, 07/10/2016 14:44:58, P, 603:51:41 3008, 43008, MMMMM, 12/09/2016 10:52:24, 11/10/2016 18:29:15, P, 703:36:27 3009, 43009, MMMMM, 12/09/2016 10:52:25, 07/10/2016 14:45:10, P, 603:51:41 3010, 43010, MMMMM, 12/09/2016 10:52:25, 07/10/2016 14:45:39, P, 603:51:42 3011, 43011, MMMMM, 12/09/2016 10:52:25, 07/10/2016 14:44:02, N, 603:51:37 3012, 43012, MMMMM, 12/09/2016 10:52:25, 07/10/2016 14:45:31, P, 603:51:42 3013, 43013, MMMMM, 12/09/2016 10:52:25, 07/10/2016 14:45:22, P, 603:51:41 3014, 43014, MMMMM, 12/09/2016 10:52:26, 07/10/2016 14:44:05, N, 603:51:37 3015, 43015, MMMMM, 12/09/2016 10:52:26, 07/10/2016 14:44:03, N, 603:51:37 ]; Right Join(tab1) tab2: LOAD [reqSIT/ID], [reqOper/ID], Timestamp(Max("result/DATA_FIM_CARGA"),'MM/DD/YYYY hh:mm:ss') As "result/DATA_FIM_CARGA" Resident tab1 Group By [reqSIT/ID], [reqOper/ID] ;