Calculation of Sum in Range??

[priyav24]

Hello Everybody,

                             I have a requirement where i need to calculate sum between two string  values say

From Name 'A' to 'D'.Is it possible to calculate.I have also attached qlikview Document for your reference..

Thanks in Advance,

Priya

[#2]

sorry I cant access your .qvw file, but i hope this might help you:

What you can do is, take the field having string value in dimension and for the expression, select the option of "accumulation" in the expression tab. from there check the Accumulation __ steps back. enter the range you want , as in 4 steps or so..

[#3]

if you want to create a range for you dimension, you can use class function :

class(MonthNum, 3,x,1) in the dimension, and take sum(Field)

this will give you a range as in:

Month         Sales

1<=x<4        10000

4<=x<7        12000

7<=x<10       11000

10<=x<13      9000

i.e. it will create a range for you dimension

[priyav24]

No these selction should be dynamic .actually user needs to select the range .So is it possible in set-analysis

[tresesco · Accepted solution]

Priya,

May be like attached sample ?