topic chart in App Development

chart

denis115 — Wed, 23 Aug 2017 07:12:37 GMT

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

micheledenardi — Wed, 23 Aug 2017 07:18:44 GMT

Please attach some example data

Re: chart

denis115 — Wed, 23 Aug 2017 07:33:30 GMT

Re: chart

pathiqvd — Wed, 23 Aug 2017 08:10:47 GMT

Hi,

Is it ok to you?

Regards,

Re: chart

denis115 — Wed, 23 Aug 2017 08:24:53 GMT

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

Thanks

Re: chart

pathiqvd — Wed, 23 Aug 2017 08:29:06 GMT

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

Anonymous — Wed, 23 Aug 2017 08:29:31 GMT

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

Re: chart

denis115 — Wed, 23 Aug 2017 08:30:10 GMT

Thanks a lot!

Re: chart

denis115 — Wed, 23 Aug 2017 08:39:44 GMT

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

pathiqvd — Wed, 23 Aug 2017 08:44:09 GMT

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

Re: chart

denis115 — Wed, 23 Aug 2017 09:12:39 GMT

it doesn't work

no dates to show

Re: chart

pathiqvd — Wed, 23 Aug 2017 09:19:58 GMT

Send Sample Data.

Re: chart

denis115 — Wed, 23 Aug 2017 09:31:41 GMT

sum(SUMI)- sum(SUMRETURN)

Re: chart

pathiqvd — Wed, 23 Aug 2017 09:50:53 GMT

Yearfield&': '&

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

Re: chart

denis115 — Wed, 23 Aug 2017 10:46:37 GMT

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

Re: chart

denis115 — Wed, 23 Aug 2017 10:52:26 GMT

Re: chart

pathiqvd — Wed, 23 Aug 2017 11:07:56 GMT

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,

Re: chart

denis115 — Wed, 23 Aug 2017 11:13:05 GMT

thanks!

Re: chart

denis115 — Wed, 23 Aug 2017 13:27:01 GMT

sample