topic Re: Cumulative line graph in QlikView

Cumulative line graph

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to create cumulative line graph

The data is like

Date Profit Capital

1/1/17 10 100

2/1/17 30 200

3/1/17 40 300

4/1/17 50 400

I want to divide Profit/Capital and want to take cumulative of that as an expression to chart.

Any suggestions?

Re: Cumulative line graph

sunny_talwar — Wed, 28 Feb 2018 17:32:19 GMT

May be like this

RangeSum(Above(Profit/Capital, 0, RowNo()))

Re: Cumulative line graph

Anonymous — Wed, 28 Feb 2018 17:34:50 GMT

if I want to sort by date in ascending order? Should i use sortable aggr?

Re: Cumulative line graph

sunny_talwar — Wed, 28 Feb 2018 17:37:51 GMT

If the sort is correct in script, then you can just use Aggr(), but if it isn't then you will have to use sortable aggr

Re: Cumulative line graph

Anonymous — Wed, 28 Feb 2018 17:44:59 GMT

In the expression for the first value,it should give default as 1 because there is no above value,like

RangeSum(Above(Profit/Capital, 0, RowNo()),1)

and can we use noofrows() instead of rowno()?

Re: Cumulative line graph

sunny_talwar — Wed, 28 Feb 2018 17:46:39 GMT

May be like this

If(RowNo() = 1, 1, RangeSum(Above(Profit/Capital, 0, RowNo())))

Will have to check based on your data if NoOfRows can work on not.... but why do you want to use it?

Re: Cumulative line graph

Anonymous — Wed, 28 Feb 2018 17:48:19 GMT

was trying out other options. Thanks

Will check with live data and mark correct answer.

Re: Cumulative line graph

zebhashmi — Wed, 28 Feb 2018 17:54:18 GMT

=Profit/Capital + Above()

Re: Cumulative line graph

Anonymous — Thu, 01 Mar 2018 08:08:09 GMT

Hi Sunny,

The above expression is giving me wrong result.

I want default value for min date to be 1,and then it should accumulate.

Re: Cumulative line graph

sunny_talwar — Thu, 01 Mar 2018 08:20:54 GMT

What would the number look like for the sample data you have provided above?

Re: Cumulative line graph

Anonymous — Thu, 01 Mar 2018 08:28:21 GMT

Hi Sunny,

I want to calculate Column F in the attached sample. Any help?

Thanks

Re: Cumulative line graph

sunny_talwar — Thu, 01 Mar 2018 11:28:51 GMT

Try this

RangeSum(Above(If(RowNo() = 1, 1, Sum(PL)/Sum(Capital)), 0, RowNo()))