Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor II

accumulative chart

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?
Tags (1)
4 Replies
Highlighted

Re: accumulative chart

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)))

Highlighted
Contributor II

Re: accumulative chart

!
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

!
Highlighted

Re: accumulative chart

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?

Highlighted
Contributor II

Re: accumulative chart

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)