18 Replies Latest reply: Aug 23, 2017 9:27 AM by cucuta denis

# 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!

• ###### Re: chart

Hi,

Is it ok to you?

Regards,

• ###### Re: chart

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

Thanks

• ###### Re: chart

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,

• ###### Re: chart

Thanks a lot!

• ###### Re: chart

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.

• ###### Re: chart

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

• ###### Re: chart

it doesn't work

no dates to show

• ###### Re: chart

Send Sample Data.

• ###### Re: chart

sum(SUMI)- sum(SUMRETURN)

• ###### Re: chart

Yearfield&': '&

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

• ###### Re: chart

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

• ###### Re: chart

Hi,

Example:-

Sales:

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,

• ###### Re: chart

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