Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
MalcolmCICWF
Creator III
Creator III

Line Chart Curves Changing Between Selections

In my Line Chart, I have a calculation to create a Cumulative % as the months proceed. It works for aStraight Table that I put the code in, but I'm guessing because of the RangeSum or Above functions, it is affecting the chart. Here is the calc being used in my straight table/Line chart and the data...

calc.PNG

straight.PNG

 

 

 

 

 

 

 

 

-If I have one ID selected it shows the smooth curve (ex. 1), then when I select multiple IDs I get dips in the curve (ex. 2) which shouldn't happen in a cumulative setting. I'm trying to get a cumulative of % over the months by each ID, the curve for the line should remain static.... Thoughts?

Ex.1

Single.PNG

Ex. 2

multi.PNG

1 Solution

Accepted Solutions
MalcolmCICWF
Creator III
Creator III
Author

I fixed it by using the incremental formula I was using and checking the "Full Accumulation" option under Accumulation in the Expressions tab.

View solution in original post

6 Replies
Kushal_Chawda

@MalcolmCICWF  try below

= sum(aggr(Rangesum(above(total sum({<YourDimension>}PaymentAmount)/sum({<YourDimension>}FaceValue),0, rowno(total))), (YourDimesion,(NUMERIC,ASCENDING))))

QFabian
Specialist II
Specialist II

Hi @MalcolmCICWF , did you try using before() instead above()?

QFabian
Kushal_Chawda

@QFabian  Before function is designed to work for pivot table only. 

MalcolmCICWF
Creator III
Creator III
Author

That one didn't work as soon as there are multiple IDs selected.

 

Capture.PNG

MalcolmCICWF
Creator III
Creator III
Author

ok so let me ask you this... In one expression I am using sum(PaymentAmount)/sum(FaceValue) to get the incremental  % each month. Can I use this expression combine with the Before function in a Line Chart to get a cumulative? All I'm really looking for is to instead of getting incremental each month, get the cumulative as the months go on... so adding in the previous month's % as each month goes on. You can see this in the straight table I provide. 

 

 

MalcolmCICWF
Creator III
Creator III
Author

I fixed it by using the incremental formula I was using and checking the "Full Accumulation" option under Accumulation in the Expressions tab.