topic Re: Possiblities..with Line Graph Cumulative in QlikView

Possiblities..with Line Graph Cumulative

Thu, 28 Jun 2012 13:24:57 GMT

Hi All,

I have a small requirement, what are the possiblities we can do the line with cumulative.

1. We should not use in built Full Accumulation.

2. Can use Rangesum functionality.

3. Any other possiblities are welcome.

Regards,

Ravi.

Hi Stephan,

Please check the latest copy of application with "chart4".

thanks reply, but if i select 27 th it should come for that date only, 28th for 27th and 28th it should come.

Regards,

Ravi.

Re: Possiblities..with Line Graph Cumulative

swuehl — Thu, 28 Jun 2012 14:32:38 GMT

Without the Full accumulation option, try something like

=aggr(rangesum(above(Sum(Values),0,RowNo())),Department,TRANSACTION_DATE)

which requires that TRANSACTION_DATE's load order is in chronological order (because aggr() will sort its dimension values by load order)

Hope this helps,

Stefan

Re: Possiblities..with Line Graph Cumulative

Fri, 29 Jun 2012 06:06:26 GMT

Hi Stephan,

Thanks for you are answer, Let me check with others ideas too.

Regards,

Ravi.

Re: Possiblities..with Line Graph Cumulative

Fri, 29 Jun 2012 09:36:20 GMT

Hi Stephan,

One more issue, if i select one date it should come whatever the possible prior date also it should come. But that is not happening.

=aggr(rangesum(above(Sum({<TRANSACTION_DATE=>}Values),0,RowNo())),Department,TRANSACTION_DATE)

Regards,

Ravi.

Re: Possiblities..with Line Graph Cumulative

swuehl — Fri, 29 Jun 2012 09:46:24 GMT

Ravi,

not sure what you mean with 'if i select one date it should come whatever the possible prior date also it should come.'

Maybe:

=sum({<TRANSACTION_DATE=>}

aggr(rangesum(above(Sum({<TRANSACTION_DATE=>}Values),0,RowNo())),Department,TRANSACTION_DATE)

)

Re: Possiblities..with Line Graph Cumulative

Fri, 29 Jun 2012 10:01:55 GMT

Hi Stephan,

thanks for your reply, but if i select 27 th it should come for that date only, 28th for 27th and 28th it should come.

Regards,

Ravi.

Re: Possiblities..with Line Graph Cumulative

Fri, 29 Jun 2012 10:04:44 GMT

Thanks stephan, It works for me..

Re: Possiblities..with Line Graph Cumulative

swuehl — Fri, 29 Jun 2012 10:10:21 GMT

Try maybe

=sum({<TRANSACTION_DATE={"<=$(=date(max(TRANSACTION_DATE)))"}>}

aggr(rangesum(above(Sum({<TRANSACTION_DATE={"<=$(=Date(max(TRANSACTION_DATE)))"}>} Values),0,RowNo())),Department,TRANSACTION_DATE)

)

to limit the date range to dates smaller equal the selected date.