topic Re: accumulative chart in QlikView

accumulative chart

omid5ive — Fri, 11 Jan 2019 11:13:46 GMT

hi
i have some data like attached excel file
i want to create some dashboard with line chart that show the sum amount of my bank transaction
i know that i can checked accumulation in my chart but i need some other things
i attached my qv dashboard too
in my case i need some group dimension with year,month and day. in first step when user see the bar it can see the amount o f my transaction in each year and for each year he/she can see sum of this year transaction and prev year. every thing is ok in first step. but when user drill down to month from fro example year 2011 he/she can just see the transaction of 2011 year but i need then end value of transaction for 2010 plus 2011 . i need it for day drill too
can any one help me?

Re: accumulative chart

sunny_talwar — Wed, 08 Feb 2017 16:04:26 GMT

Try this:

If(GetSelectedCount(ddate_year) = 0, RangeSum(Above(Sum(amount), 0, NoOfRows(TOTAL))),

If(GetSelectedCount(ddate_month) = 0, Aggr(RangeSum(Above(TOTAL Sum({<ddate_day, ddate_month, ddate_year, MonthYear>}amount), 0, NoOfRows(TOTAL))), MonthYear),

Aggr(RangeSum(Above(TOTAL Sum({<ddate_day, ddate_month, ddate_year, MonthYear>}amount), 0, NoOfRows(TOTAL))), MonthYear, ddate_day)))

Re: accumulative chart

omid5ive — Fri, 11 Jan 2019 11:14:30 GMT

!
hi sunny
thanks for your reply
i set my chart same as you said but i think something is going wrong can you see the attached file?
my date is persian date

!

Re: accumulative chart

sunny_talwar — Sun, 12 Feb 2017 00:40:23 GMT

You mentioned something is going wrong, but would you be able to elaborate what the issue is? I am not entirely sure I know what is wrong?

Re: accumulative chart

omid5ive — Sun, 12 Feb 2017 05:56:54 GMT

in first picture that i attached you can see the amount in 11 month but when i drill to day in this month the last amount is other thing (pic2)