Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
BouwerVa
Contributor II
Contributor II

Running Balance Line Chart

Hi 

I made the following line chart showing our daily LG. But I would like the line to increase with each days LG.

I add a Screenshot with the Line Chart and Dimension. The Chart is filtered for a Specific Month.

Capture.JPG

 

 

9 Replies
kaushiknsolanki

Hi,

I guess what you are looking for is a cumulative chart.

Here is the link to know how to do it.

https://www.youtube.com/watch?time_continue=3&v=AlT_jAMsiGU

 

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
BouwerVa
Contributor II
Contributor II
Author

It is working in Table but not in Line Chart

Capture.JPG 

kaushiknsolanki

Hi, Did you check the video?

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
BouwerVa
Contributor II
Contributor II
Author

Yes

Here is my Formula:

RangeSum( Above( Sum(if(TTYPE = 'Lo' and TGROUPTYPE = 'Lo', CAPITAL)),0,RowNo() ) )

kaushiknsolanki

Hi,

Can you share the sample qvf file.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
BouwerVa
Contributor II
Contributor II
Author

It is working in the table in the Screenshot above.

But when I convert the table to line graph is doesn't work

kaushiknsolanki

Hi,

I need to understand whats going wrong and thus i need the sample qvf.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
BouwerVa
Contributor II
Contributor II
Author

See Attached qvf

It is under the Daily LG Sheet

BouwerVa
Contributor II
Contributor II
Author

Hi

Any luck on solving the problem?

Did you have time to have a look at the qvf?