Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
denis115
Creator
Creator

chart

Hello ! Help please,I have a chart and I need to have numbers in percentage above each year. I select  year 2016 and 2017 and in chart I need to see difference beetwen this years in percentage, how can I do this?

Thank you!

18 Replies
denis115
Creator
Creator
Author

it doesn't work

no dates to show

pathiqvd
Creator III
Creator III

Send Sample Data.

denis115
Creator
Creator
Author

sum(SUMI)- sum(SUMRETURN)

pathiqvd
Creator III
Creator III

Yearfield&': '&

num(aggr(((sum(SUMI)-sum(SUMRETURN))-Above((sum(SUMI)-sum(SUMRETURN))))/(sum(SUMI)-sum(SUMRETURN)),Yearfield),'##.## %')

denis115
Creator
Creator
Author

It doesn't helped me... maybe my question wasn't correct, no data for show... 

denis115
Creator
Creator
Author

pathiqvd
Creator III
Creator III

Hi,

Example:-

Sales:

load * Inline [

Yearr,SUMI,SUMRETURN

2015,400,200

2016,200,300

2017,700,600

];

Dim:-

=Yearr&': '&

num(aggr(((sum(SUMI)-sum(SUMRETURN)) -above((sum(SUMI)-sum(SUMRETURN))))/(sum(SUMI)-sum(SUMRETURN)),Yearr),'##.## %')

--> Mean(2016-2015/2016)....

Expr:-

=sum(SUMI)-sum(SUMRETURN)

Regards,

denis115
Creator
Creator
Author

thanks!

denis115
Creator
Creator
Author

sample