Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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,
Please attach some example data
Hi,
Is it ok to you?
Regards,
Can you explain me please your steps? I'd like to have difference in percentage above each year , not near.
Thanks
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,
I presume your question is regarding QlikSense, and unfortunately this cannot be done with out of the box QlikSense.
Thanks a lot!
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.
=Year&': '&num(aggr((sum(SUMI)-sum(SUMRETURN))/sum(SUMI),Year),'##.## %')