topic Percent Change Combo Chart in QlikView

Percent Change Combo Chart

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

I have the below expression in a combo chart

=If(STARTDATE_YYYYMM >= Max(TOTAL STARTDATE_YYYYMM, 6), Below(RangeSum(Below(Count({<STATUS = {'Open'}>}ID), 0, NoOfRows() - RowNo() + 1))) + Count(ID)) Works Perfectly!

Now I would like to create a line chart that shows a percent change from month to month.

201607 should be 3.8 % % difference between 49,910 and 48,006

201606 - 8.17 %

Re: Percent Change Combo Chart

sunny_talwar — Fri, 22 Jul 2016 19:05:28 GMT

May be this:

=If(STARTDATE_YYYYMM >= Max(TOTAL STARTDATE_YYYYMM, 6), Below(RangeSum(Below(Count({<Status = {'Open'}>}id), 0, NoOfRows() - RowNo() + 1))) + Count(id))

/ If(STARTDATE_YYYYMM >= Max(TOTAL STARTDATE_YYYYMM, 6), Below(Below(RangeSum(Below(Count({<Status = {'Open'}>}id), 0, NoOfRows() - RowNo() + 1))) + Count(id))) - 1