Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with script for data selection

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
1 Solution

Accepted Solutions
danieloberbilli
Specialist II
Specialist II

What about that...pfa the .qvw file

View solution in original post

3 Replies
danieloberbilli
Specialist II
Specialist II

What about that...pfa the .qvw file

Not applicable
Author

Daniel,

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

Best regards,

Americo Panichi

danieloberbilli
Specialist II
Specialist II

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