Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
konidena
Contributor

How to show the percentage change in combo chart

Hi Team,

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)

Regards

Srinivas

9 Replies

Re: How to show the percentage change in combo chart

May be like this:

Sum(Paidvalue)/Above(Sum(Paidvalue)) - 1

konidena
Contributor

Re: How to show the percentage change in combo chart

I Tried this Suny, but it is not working as expected.

Re: How to show the percentage change in combo chart

Would you be able to share a sample with the expected output?

MVP
MVP

Re: How to show the percentage change in combo chart

Alt((SUM(Paidvalue) - Above(SUM(Paidvalue)))/Above(SUM(Paidvalue)),0)

MVP
MVP

Re: How to show the percentage change in combo chart

or use this

Dual(SUM(Paidvalue) & CHR(10)& Num(Alt((SUM(Paidvalue) - Above(SUM(Paidvalue)))/Above(SUM(Paidvalue)),0),'#0.0%'), SUM(Paidvalue))

galax_allu
Valued Contributor

Re: How to show the percentage change in combo chart

Combo Chart with accumulation and % change

Please look in to the above link ....

again thanks to SUNNY....

konidena
Contributor

Re: How to show the percentage change in combo chart

Sunny, it is in the client network. So, not able to post the sample here

konidena
Contributor

Re: How to show the percentage change in combo chart

Team,

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.

Highlighted
Partner
Partner

Re: How to show the percentage change in combo chart

please share your application. so that it is easy for us to write the correct expression

-Sathish