topic Re: above function in QlikView

above function

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

Hi Team,

I have below data.

Test:

LOAD * inline [

Year ,Month ,Sales

2015 ,January, 10

2015, February,20

2015 ,March ,30

2014 ,January ,10

2014 ,February,20

2014 ,March ,30

2013 ,January ,10

2013 ,February ,20

2013 ,March,30

]

I am expecting output of

Thanks,

Villyee

sunny_talwar — Thu, 25 Jan 2018 18:06:10 GMT

Try Above(TOTAL Sum(sales))

vanderson009 — Thu, 25 Jan 2018 18:09:32 GMT

Thanks sunny it worked, but may i know How Total is working.

sunny_talwar — Thu, 25 Jan 2018 18:14:30 GMT

check here