Help with script for data selection

Fri, 01 May 2015 00:37:00 GMT

Good night everyone!

I am working in a bank table with debit and credit entries and the calculation of balance. This part is ready and works perfectly. I need help to load in the script column "flag" to select the current balance value of the day. When more than a launch on the same day is the difficulty begins, since I can not add up all the results of the balance of this day, I need only the last daily balance record. below is an example of the table.

Already much I appreciate the attention of everyone who can help me. Best regards.

I need all the current balance records every day, but when one day presents more of a release on the same day, takes only the last record of the day, highlighted below.

IdSequential	Date	Bank	Balance	Flag
142004	31/12/2014	39	R$ 500,00	1
242006	02/01/2015	39	R$ 400,01	1
342009	05/01/2015	39	-R$ 599,98	0
442009	05/01/2015	39	-R$ 1.498,98	0
542009	05/01/2015	39	-R$ 1.597,98	1
642010	06/01/2015	39	-R$ 1.697,88	0
742010	06/01/2015	39	-R$ 1.797,78	0
842010	06/01/2015	39	-R$ 11.797,67	0
942010	06/01/2015	39	-R$ 11.897,57	1
1042012	08/01/2015	39	-R$ 111.797,561	0
1142012	08/01/2015	39	-R$ 211.797,55	1
1242016	12/01/2015	39	-R$ 211.895,55	1
1342018	14/01/2015	39	-R$ 211.995,45	1
1442020	16/01/2015	39	-R$ 221.995,44	0
1542020	16/01/2015	39	-R$ 231.994,44	1
1642023	19/01/2015	39	-R$ 232.994,43	0
1742023	19/01/2015	39	-R$ 233.094,33	0
1842023	19/01/2015	39	-R$ 233.193,33	1
1942026	22/01/2015	39	-R$ 333.192,22	0
2042026	22/01/2015	39	-R$ 343.192,21	0
2142026	22/01/2015	39	-R$ 443.192,20	0
2242026	22/01/2015	39	-R$ 443.291,20	0
2342026	22/01/2015	39	-R$ 453.281,19	1

Re: Help with script for data selection

danieloberbilli — Fri, 01 May 2015 03:08:13 GMT

What about that...pfa the .qvw file

Re: Help with script for data selection

Fri, 01 May 2015 05:35:49 GMT

Daniel,

I am very grateful. The script worked perfectly, thank you so much for your attention.

Best regards,

Americo Panichi

Re: Help with script for data selection

danieloberbilli — Fri, 01 May 2015 05:42:05 GMT

Thanks, Americo. Happy that the script helps.

Please do not forget to mark my answer as 'Correct Answer'. This also helps other users to find a solution when they are facing a similar problem.

Thanks.

Cheers

Daniel

topic Help with script for data selection in QlikView

Help with script for data selection

Re: Help with script for data selection

Re: Help with script for data selection

Re: Help with script for data selection