topic Re: Above function in QlikView

Above function

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

Hi,

I am trying to get %growth using above function. I have trade month, tradername as dimension and expression is sum(value). Using above function in expression (sum(value)-above(sum(value))/above(sum(Value))... This doesn't seem to be working in a line chart. It works in a table but line chart the % nos changes.

Can anyone please assist.

Thanks

Re: Above function

sunny_talwar — Wed, 30 Nov 2016 19:15:05 GMT

Try this:

(Sum(value) - Aggr(Above(Sum(value)), tradename, month))/Aggr(Above(Sum(value)), tradename, month)

Re: Above function

rupamjyotidas — Wed, 30 Nov 2016 19:19:40 GMT

Above function would work in Table chart.

sum({<Month={ $(Month-1) }>} Sales))

/sum(Sales) - 1

Re: Above function

tellmalaika17 — Thu, 01 Dec 2016 14:33:56 GMT

Hi Sunny,

Thanks for the reply. Above function will not work in the line chart so this expression is not working.

Tried this in a table chart and it works but not in line chart.

Is there any other function I can use to get %growth in a line chart.

Re: Above function

tellmalaika17 — Thu, 01 Dec 2016 14:34:17 GMT

Yes works in a table chart.

Re: Above function

sunny_talwar — Thu, 01 Dec 2016 14:36:29 GMT

Why would it not work in line chart ? Can you share a sample where it isn't working and I may be able to tweak it to work