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!

1 Solution

Accepted Solutions
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,

View solution in original post

18 Replies
micheledenardi
Specialist II
Specialist II

Please attach some example data

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
denis115
Creator
Creator
Author

pathiqvd
Creator III
Creator III

Hi,

  Is it ok to you?

perissue.JPG

Regards,

denis115
Creator
Creator
Author

Can you explain me please your steps? I'd like to have difference in percentage above each year , not near.

Thanks

pathiqvd
Creator III
Creator III

Hi,

  Above Year not possible. We can show near.

Dim;-

Year&': '&

num(aggr(RangeSum(sum(Sales)-Above(sum(Sales)))/sum(Sales),Year),'##.## %')

Expr:-

sum(Sales)


Regards,

Anonymous
Not applicable

I presume your question is regarding QlikSense, and unfortunately this cannot be done with out of the box QlikSense.

denis115
Creator
Creator
Author

Thanks a lot!

denis115
Creator
Creator
Author

One more question

In my expression I use :

sum(SUMI)-sum(SUMRETURN)

What I need to do because I not really understand how to do next steps.

Thanks.

pathiqvd
Creator III
Creator III

=Year&': '&num(aggr((sum(SUMI)-sum(SUMRETURN))/sum(SUMI),Year),'##.## %')