Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
hemanthaanichet
Creator III
Creator III

To show growth of current year MAT vs previous year MAT in bar chart

Hi All,

I have a max data of Jun 2016 in my Table and have to take the growth comparing current year 12 months vs  previous year 12 months from the max data having for the current year.

Am using Yearmonth as a dimension in Bar chart

and using below given expression:

(Sum({<Yearmonth ={">=$(=date(addmonths(date#(max(Yearmonth ),'MMM-YY'),-11),'MMM-YY')) <=$(=max(Yearmonth ))"}>}NVALUE)

-

Sum({<Yearmonth ={">=$(=Date(Addmonths(Addyears(Date#(Max(Yearmonth ),'MMM-YY'),-1),-11),'MMM-YY')) <=$(=Date(Addyears(Date#(Max(Yearmonth ),'MMM-YY'),-1),'MMM-YY'))"} >} NVALUE))

/

(Sum({<Yearmonth ={">=$(=Date(Addmonths(Addyears(Date#(Max(Yearmonth ),'MMM-YY'),-1),-11),'MMM-YY')) <=$(=Date(Addyears(Date#(Max(Yearmonth ),'MMM-YY'),-1),'MMM-YY'))"} >} NVALUE)) 

i wanna to show to the chart like below but in bar chart

Latest 12months.PNG

Regards

Hemanth

25 Replies
hemanthaanichet
Creator III
Creator III
Author

you can achieve by

in expression tab

first expression : sales expression

second expression : growth expression     

in the same tab you may find display options

for first expression check mark bar

for second expression check mark the line

sunny_talwar

Would you be able to share a sample to see the issue?

tanykozel
Contributor II
Contributor II

Сервис хранения и передачи файлов - FEX.NET

You can get in from link above.

So, I can show growth only for months in  max chosen year, but need to show for all months if it's chosen more than 2 year...

Capture.JPGCapture1.JPG

Thank you !

I'm a new user in QV...

sunny_talwar

Remove this part from your denominator

Capture.PNG

tanykozel
Contributor II
Contributor II

thank you Sunny,

I removed,

But when want to chose only one year got not very nice picture ... Can we remove figures of growth where not  sales ? thanxCapture.JPG

tanykozel
Contributor II
Contributor II

i got it ))))

thank you again