topic RangeAvg adding two different fields in QlikView

RangeAvg adding two different fields

Tue, 01 May 2012 15:22:24 GMT

How do I take this expression and add ClientSideActivity.Days Booked as well. So I want the same equation only adding both fields. So I tried number 2, but this doesn't work. Can anyone assist me in the correct syntax for number 1 expression adding in the Client side? Thank you in advance.

1. if(Week <=today(),(rangeavg(above([ProviderSideActivity.Days Booked],0,13))))

2. if(Week <=today(),(rangeavg(above([ProviderSideActivity.Days Booked],0,13))))+

if(Week <=today(),(rangeavg(above([ClientSideActivity.Days Booked],0,13))))

(O)nePuttGirl

RangeAvg adding two different fields

Fri, 04 May 2012 12:54:08 GMT

Does your first expression work?

If so, you could try the second expression without the second if(Week <=today().

if(Week <=today(),

rangeavg(above([ProviderSideActivity.Days Booked],0,13))+rangeavg(above([ClientSideActivity.Days Booked],0,13))

)

RangeAvg adding two different fields

Fri, 04 May 2012 14:39:03 GMT

Yes, the first expression works. I tried your expression and I don't get a trend line. I get to maybe add them in the load script unless you have any other ideas?

Thank you for you response,

(O)nePuttGirl