Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to plot Cumulative Curve

Hello Guys,

I need to plot two different cumulative curve

1. Cumulative curve

Dimension :-   Year(LoadedDate)*100+Month(LoadedDate)

Measure:-      Sum(Load)

2. Cumulative Curve

Dimension :-   Year(LoadedDate)*100+Month(LoadedDate)

Dimension :-   (Round((HitRateProjects*100),0.01)*[Hours Flow4])

Measure:-      Sum(Load)

Additional Info :- I have Unique projects Id for 300 projects

Thanks In Advance,

Ravi

1 Solution

Accepted Solutions
sunny_talwar

6 Replies
sunny_talwar

Why don't you first create this in the script

LOAD Year(LoadedDate)*100+Month(LoadedDate) as YearMonth


and then try this


Dimension

YearMonth


Expression

RangeSum(Above(Sum(Load), 0, RowNo()))

For the second chart, may be it might make sense to do the manipulation in the script for the second dimension also

LOAD (Round((HitRateProjects*100),0.01)*[Hours Flow4]) as Dimension2

and then may be this

Dimension

YearMonth

Dimension2

Expression

Aggr(RangeSum(Above(Sum(Load), 0, RowNo())), Dimension2, YearMonth)


Anonymous
Not applicable
Author

Thanks sunny for immediate response !

I have to plot Cumulative Line Curve . So Should I be using Extensions Such as D3 Visualization Library or Normal Line Curve in both the cases .

So Measure:-  Sum(Load)  where Load field contains Decimal values for all 300 projects

Should it remain the same ?


thanks,

ravi


sunny_talwar

For accumulated line, I don't think you need an extension... but since I have not seen you data, I wouldn't know. Would you be able to share a sample

Anonymous
Not applicable
Author

hey Sunny,

yes sure, i am sharing a xlsx file which has the required data .

sunny_talwar

Check attached

Capture.PNG

Anonymous
Not applicable
Author

Thanks Sunny

thanks a ton for giving me a solution ! It worked for me .