Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ndeeleysww
Contributor

Conditional field in Rangesum

Hi,

I'm calculating a rangesum which takes in all the dates in my data:

rangesum(

above(

(

(avg(If(Month([BlankDate])='Nov',([Winter Weekly]),

If(Month([BlankDate])='Dec',([Winter Weekly]),

If(Month([BlankDate])='Jan',([Winter Weekly]),

If(Month([BlankDate])='Feb',([Winter Weekly]),

If(Month([BlankDate])='Mar',([Winter Weekly]),

If(Month([BlankDate])='Apr',([Low Weekly]),

If(Month([BlankDate])='May',([Low Weekly]),

If(Month([BlankDate])='Jun',([Low Weekly]),

If(Month([BlankDate])='Jul',([Peak Weekly]),

If(Month([BlankDate])='Aug',([Peak Weekly]),

If(Month([BlankDate])='Sep',([Low Weekly]),

If(Month([BlankDate])='Oct',([Low Weekly])))))))))))))

)

)

/7

),0,RowNo()

)

)

However, I need to constraint the start row of the rangesum to a particular date, in this case the Max([PickupDate]). How and where can I add this into the rangesum?

Thanks in advance!

Neil

Tags (3)
Community Browser