Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Running Total

Hi All,
I have a table which has following fields(Columns)
Date,Cdefect,CIDefects and Odefects.
As shown in the below screenshot.

Data.PNG
Now i have to come up with a output table which should show me running total.
where the Odefect will be added to Cdefect and the result will be Subracted from CIDefect and provides the output in Total
this is how it repeats.
Below is the screenshot of the Out put .

output.PNG

Can you please help me in achieving this

Thanks in Advance

 

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Running Total

There you go:

clipboard_image_0.png

Build a new column (Total) at script level.

Refer attached qvw for the logic using peek() function.

Thanks and regards,

Arthur Fong

View solution in original post

1 Reply
Highlighted
Partner
Partner

Re: Running Total

There you go:

clipboard_image_0.png

Build a new column (Total) at script level.

Refer attached qvw for the logic using peek() function.

Thanks and regards,

Arthur Fong

View solution in original post