topic Re: Line Chart Curves Changing Between Selections in QlikView

Line Chart Curves Changing Between Selections

MalcolmCICWF — Sat, 16 Nov 2024 17:44:54 GMT

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...

-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

Ex. 2

Re: Line Chart Curves Changing Between Selections

Kushal_Chawda — Thu, 03 Dec 2020 22:10:02 GMT

@MalcolmCICWF try below

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

Re: Line Chart Curves Changing Between Selections

QFabian — Thu, 03 Dec 2020 22:41:38 GMT

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

Re: Line Chart Curves Changing Between Selections

Kushal_Chawda — Thu, 03 Dec 2020 23:06:17 GMT

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

Re: Line Chart Curves Changing Between Selections

MalcolmCICWF — Fri, 04 Dec 2020 16:03:30 GMT

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

Re: Line Chart Curves Changing Between Selections

MalcolmCICWF — Fri, 04 Dec 2020 16:23:52 GMT

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.

Re: Line Chart Curves Changing Between Selections

MalcolmCICWF — Wed, 09 Dec 2020 19:26:35 GMT

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