Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Rangesum Formula from Expression field

Hello!

I'd like to create a new dimension to get the sum  of the  Key Term Demand's  13 weeks and past due from an expression field...

                    Key Term                Past Due             Week1   Week 2   Week3 ------> Week 13

                   

                    Demand                      10                       20            30               40            50

                    Supply                         15                         0            10              40               60

                    Forecast                      12                           10           40           10             70

In my sample above, I'd like to add the Demand from Past Due to week 13...The sum would then be divided into 13. Do i need toi use rangesum on this ?

Tks.

0 Replies