Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ravishinge
Contributor

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

Re: How to plot Cumulative Curve

Check attached

Capture.PNG

6 Replies

Re: How to plot Cumulative Curve

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)


ravishinge
Contributor

Re: How to plot Cumulative Curve

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


Re: How to plot Cumulative Curve

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

ravishinge
Contributor

Re: How to plot Cumulative Curve

hey Sunny,

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

Re: How to plot Cumulative Curve

Check attached

Capture.PNG

ravishinge
Contributor

Re: How to plot Cumulative Curve

Thanks Sunny

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

Community Browser