Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

biggusdoggus
Contributor

Cumulative output not wanted

Hi.

I have the following:

if(Sum(if(year(TRANS_DATE)=2016, QTY,0))>0,  rangesum( above( sum(if(year(TRANS_DATE) = 2016,QTY,0)),0,rowno())),null).

Call it MTD 2016.

It's for a bar chart, which I want to show the monthly QTY actuals for 2016, 2015 and 2014.

However, it is showing a cumulative result month on month, not monthly QTY actuals.

I have zero doubt it is extremely simple to fix. However, I am clearly simpler, and can't do it. Any help greatly appreciated thanks!

1 Solution

Accepted Solutions
biggusdoggus
Contributor

Re: Cumulative output not wanted

Actually, never mind. Worked it out - just straight Sum(if(year(TRANS_DATE)=2016, QTY,0))

Thanks for reading my question though!

1 Reply
biggusdoggus
Contributor

Re: Cumulative output not wanted

Actually, never mind. Worked it out - just straight Sum(if(year(TRANS_DATE)=2016, QTY,0))

Thanks for reading my question though!