Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Valued Contributor II

Re: Help with script for data selection

What about that...pfa the .qvw file

3 Replies
danieloberbilli
Valued Contributor II

Re: Help with script for data selection

What about that...pfa the .qvw file

Not applicable

Re: Help with script for data selection

Daniel,

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

Best regards,

Americo Panichi

danieloberbilli
Valued Contributor II

Re: Help with script for data selection

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