Discussion Board for collaboration related to QlikView App Development.
I have combo chart in my application.
In this, the bars are displaying for 12 months. If the current month is Dec, then the bars are displaying from Jan 2016 to Dec 2016
If user selected the month Jul in the year 2016, then it is showing Aug of the 2015 to Jul in 2016.
now, my requirement is to display the line showing the percentage change from month month in the bars.
I have selected Jul 2016 as my current month in the attached file. so , it is displaying from 2015 aug to 2016 Jul
How to calculate the % change without changing the sort order.
Here the Express is Sum(Paidvalue)
May be like this:
Sum(Paidvalue)/Above(Sum(Paidvalue)) - 1
I Tried this Suny, but it is not working as expected.
Would you be able to share a sample with the expected output?
Alt((SUM(Paidvalue) - Above(SUM(Paidvalue)))/Above(SUM(Paidvalue)),0)
or use this
Dual(SUM(Paidvalue) & CHR(10)& Num(Alt((SUM(Paidvalue) - Above(SUM(Paidvalue)))/Above(SUM(Paidvalue)),0),'#0.0%'), SUM(Paidvalue))
Combo Chart with accumulation and % change
Please look in to the above link ....
again thanks to SUNNY....
Sunny, it is in the client network. So, not able to post the sample here
All the above are working fine only when the month numbers are in sequence in the single year. If the months are from different years, i am not getting the correct %change values.
please share your application. so that it is easy for us to write the correct expression