Forecast

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

Hi friends

I am trying to add field “other” and remove the subtraction calculation from below expressions. Before I had 3 columns, now one more column has been created so I do not have to use subtraction to get "other". Help please. I have tried few ways but column fields are coming up with - .

if([F Group]='UK', sum({<Year={"$(ThisYearByOrderDate)"}>} [UK Forecast]),

if([F Group]='USA', sum({<Year={"$(ThisYearByOrderDate)"}>} [USA Forecast]),

if([F Group]='EU’, sum({<Year={"$(ThisYearByOrderDate)"}>} [EU Forecast]),

if([F Group]='Other', sum({<Year={"$(ThisYearByOrderDate)"}>} [Forecast] - (if(isnull([UK Forecast]), 0, [UK Forecast]))

- (if(isnull([USA Forecast]), 0, [USA Forecast]))-(if(isnull([EU Forecast]), 0, [EU Forecast])))

,sum({<Year={"$(ThisYearByOrderDate)"}>} [Forecast])))))

I am using below but it’s is not working:

if([F Group]='UK', sum({<Year={"$(ThisYearByOrderDate)"}>} [UK Forecast]),

if([F Group]='USA', sum({<Year={"$(ThisYearByOrderDate)"}>} [USA Forecast]),

if([F Group]='EU’, sum({<Year={"$(ThisYearByOrderDate)"}>} [EU Forecast]),

if([F Group]='Other’, sum({<Year={"$(ThisYearByOrderDate)"}>} [Other Forecast]), [Forecast]))))

Re: Forecast

madhuqliklondon — Fri, 14 Jul 2017 14:41:05 GMT

Got it, done now by following expression.

if([F Group]='UK', sum({<Year={"$(ThisYearByOrderDate)"}>} [UK Forecast]),

if([F Group]='USA', sum({<Year={"$(ThisYearByOrderDate)"}>} [USA Forecast]),

if([F Group]='EU’, sum({<Year={"$(ThisYearByOrderDate)"}>} [EU Forecast]),

if([F Group]='Other’, sum({<Year={"$(ThisYearByOrderDate)"}>} [Other Forecast]), sum({<Year={"$(ThisYearByOrderDate)"}>}[Forecast])))))

topic Re: Forecast in QlikView

Forecast

Re: Forecast