Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
konidena
Creator
Creator

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
sunny_talwar

May be like this:

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

konidena
Creator
Creator
Author

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

sunny_talwar

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

MK_QSL
MVP
MVP

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

MK_QSL
MVP
MVP

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

Combo Chart with accumulation and % change

Please look in to the above link ....

again thanks to SUNNY....

konidena
Creator
Creator
Author

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

konidena
Creator
Creator
Author

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.

sathishkumar_go
Partner - Specialist
Partner - Specialist

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

-Sathish