Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
ravishinge
Contributor

Cumulative Line Chart

Hello Guys,

I need to plot Number of Hours vs No months In a Line chart . I wanted to show a nice cumulative curve .Could you  please help me with this . My sample data is shown as below though there are lot of values I am just showing few .

HoursMonths
2001
6002
10003
15004

My months expression is :- (If(( Flow='3'),Round((((( fabs(If (''LOI''<0,(''LOI''))*Hours)/Days)))/730.0008),0.01),Null() ))

My months expression works fine .

SO kindly help me how do I plot cumulative line chart.

Thanks,

ravi

2 Replies
felipedl
Valued Contributor III

Re: Cumulative Line Chart

Hi Ravi,

What you want to achieve you could do with RangeSum.

I've made a A simple sample app with your data with the following expression:

rangesum(above( sum(REVENUE), 0, rowno() ))

wich gives the cumulative \aspect your searching for.

Attached the app I made, hope it helps.

Felipe.

ravishinge
Contributor

Re: Cumulative Line Chart

Hello Felipe,

Thanks a lot for replying !

Yes it worked to some extent .

Now I have data something like this as show below in the image where you can see there are multiple

Flow Number 4 and 1 and which has multiple values assigned. So in this case I am not able to get curve . So how do I handle this ?

Flow3 field is my dimension

and the big expression is my Measure .

Kindly help me with this .....

790cb5d654ee4813b9288cc3f284a1cb.png