Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
PSCET
Contributor
Contributor

YTD Growth for five years for three companies in a graph

I have to plot 5 years of Sales growth in a graph for three companies.

Formula uses is - 

(Sum(Sales)/Above(TOTAL Sum(Sales))-1)*100

 

but the above is working for only one Company and not working for three.

 

I have tried the following also 

 

=(aggr((Sum(Sales)/above(total Sum(Sales))-1)*avg(1),[Company],FY))

The above is showing accurate values for few FY and incorrect values for some years.

 

Please guide.

 

Labels (1)
2 Replies
sidhiq91
Specialist II
Specialist II

@PSCET  Could you please provide some sample data set?

PSCET
Contributor
Contributor
Author

Sample data enclosed. I have to plot growth of three companies for there FY in a single chart.

 

Thanks in advance