Problems using the accumulated.

[Anonymous]

Hi!

I have a trouble using cumulative function:

I have months (Month field) and a value for each month (Index),and I need to create one chart showing the points accumulated by months.

The problem I have is that the values ​​for each month are percentages(value index is percentage),

so i can not simply use the cumulative function cause it is use for natural numbers(sum), and i have percentages.

One example:

What I need is for March show the point:

Point = (avg(values for Index in January) + avg(values for index in February )+ avg(values for index in March) / 3

and so on for April ... etc

Can anyone tell me how to get it?

Activating the cumulative tab does not work properly because they are PERCENTAGES what I have, not natural numbers.

Thanks a lot!

Paula.

[munna1317]

hi, plz pin an example with qvw file

regards ,

harish

[Anonymous]

Hi Harish,

thanks for your support.

Let me explain again the problem !

I have this fields

Month              Provider    Index

01_2012          Pepe          100

01_2012          Jose            100

01_2012          Ramon        98

01_2012          Juan              100

02_2012          Pepe            65

02_2012          Jose              100

02_2012          Ramon            72

03_2012          Pepe            100

03_2012          Juan              100

04_2012          Pepe              89

04_2014          Ramon          92

I want to create a  mixed chart (bar chart with lines) like the photo i

attached(photo1).

I have achieved the expression fot the bar chart: avg(), and if i want

the accumulated , i will active "acumular" (pantallazo1), but i have percentage

values (100, 100, 98... etc)

and i don't know how to achieve the chart i have to create.

Thanks for yout time

El 3 de septiembre de 2014 a las 10:57 A Harish <qcwebmaster@qlikview.com>

escribió:

Qlik Community <http://community.qlik.com/>

Problems using the accumulated.

reply from A Harish

<http://community.qlik.com/people/munna1317?et=watches.email.thread> in New to

QlikView - View the full discussion

<http://community.qlik.com/message/600364?et=watches.email.thread#600364>

>

[Anonymous · Accepted solution]

Please refer to the attached file...

Hope this is your requirement................

Regards

Nitin

[Anonymous]

Thanks a lot Nitin!

It's Perfect!

but .. you can explain me a bit this expression?

rangeavg (above(avg(Index),0,RowNo()))

I'm fascinated.

Regards, Paula

El 3 de septiembre de 2014 a las 12:03 Nitin Gupta <qcwebmaster@qlikview.com>

escribió:

Qlik Community <http://community.qlik.com/>

Re: Problems using the accumulated.

reply from Nitin Gupta

<http://community.qlik.com/people/gupta.n8?et=watches.email.thread> in New to

QlikView - View the full discussion

<http://community.qlik.com/message/600472?et=watches.email.thread#600472>

>

[Anonymous]

Even you can get help in help document on Range functions...

What it do is it is calculating the average by defining the range of values calculated for previous dimension and the current one....