topic Re: chart in QlikView

chart

denis115 — Wed, 25 Nov 2020 16:16:04 GMT

Hello! I've got a problem. Can I show difference in percentage between two or more years in a histogram?

It must look like :

for example : Sales from 2015 are more than in 2014 by 50% but sales from 2016 are lower than in 2015 by 15%.

Can I do this with out entering in script? only by adding an expression in properties of chart? Please help me.

Re: chart

denis115 — Thu, 24 Aug 2017 05:21:52 GMT

my expression for calculating is sum(SUMI)-sum(SUMRETURN)

Re: chart

tresB — Thu, 24 Aug 2017 05:25:56 GMT

What if you have two more years say, 2017 and 2018? What would be your expected output then?

Re: chart

denis115 — Thu, 24 Aug 2017 05:41:04 GMT

what do you mean?

Re: chart

tresB — Thu, 24 Aug 2017 05:53:30 GMT

Please, ignore my previous comment and try to share your sample qvw to work on.

Re: chart

denis115 — Thu, 24 Aug 2017 05:59:30 GMT

sample

Re: chart

tresB — Thu, 24 Aug 2017 06:02:43 GMT

Which one is your year field?

Re: chart

denis115 — Thu, 24 Aug 2017 06:04:53 GMT

first one

Re: chart

denis115 — Thu, 24 Aug 2017 06:19:20 GMT

is there any question?

Re: chart

tresB — Thu, 24 Aug 2017 06:40:52 GMT

Like this?

Re: chart

denis115 — Thu, 24 Aug 2017 06:49:49 GMT

Super, I think that is what I need ! What I need to do for this result?

Re: chart

tresB — Thu, 24 Aug 2017 06:54:51 GMT

Please check the attached sample.

Expression used:

Dual( if(RowNo()=1, '',

Num(((sum(SUMI)-sum(SUMRETURN))-Above(sum(SUMI)-sum(SUMRETURN)))

Above(sum(SUMI)-sum(SUMRETURN)),'# ##0.00%')),

sum(SUMI)-sum(SUMRETURN)

)

Re: chart

denis115 — Thu, 24 Aug 2017 06:56:58 GMT

Thank you so much!!!

Re: chart

denis115 — Thu, 24 Aug 2017 12:44:02 GMT

There is a problem

It was so close but something need to add because I want to see number of sales not a percentage and also I need to see percentage but only above segments, what do I need to do? Help please...