Discussion board where members can learn more about Qlik Sense App Development and Usage.
I need to plot two different cumulative curve
1. Cumulative curve
Dimension :- Year(LoadedDate)*100+Month(LoadedDate)
2. Cumulative Curve
Dimension :- (Round((HitRateProjects*100),0.01)*[Hours Flow4])
Additional Info :- I have Unique projects Id for 300 projects
Thanks In Advance,
Go to Solution.
Why don't you first create this in the script
LOAD Year(LoadedDate)*100+Month(LoadedDate) as YearMonth
and then try this
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
Aggr(RangeSum(Above(Sum(Load), 0, RowNo())), Dimension2, YearMonth)
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 ?
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
yes sure, i am sharing a xlsx file which has the required data .
thanks a ton for giving me a solution ! It worked for me .