Aggregated Data

[#1]

Dear all,

I need a output like this:

in Column C if you note it is having a aggregate Data of Column B. Can any one help me regarding this issue

[#2]

Well Column4 div Column 1 would give the results you put in MyOutput.

60/1=60

100/2=50

170/3=56.6

...

I don't know where the results in the yellow column come frome and what is wrong with the above output.

[#3]

That what i need to but i am not able to do that ... as Data in column Acc Data is Accumulated ... when i do any division it willnot take a accumulated data.

Have a look on my QVW attached above you will come to know

Thanks for your Concern ....

[#4]

For the moment I can think of one possible workaround. See attachment.

But this forces you to keep the data sorted by Date (ascending or descending).

[#5]

Hi Przemek,

Thanks Dude,

well i am new to Qlik view and was not aware of these functions can you share some document regarding the functions if you haveany?

Like this Rangesum how it works? even in qlikview  Help i am getting some Bouncers ......

[#6]

Hi Przemek,

Sorry for the trouble can you help me with same but this time i need a Count rather then Sum....

I have attached the Qvw please have a look on that ... i tried with the Logic you implimented for Sumbut its not working ....

[#7]

Hi

Check the attached document. I added a counter field to the load script and used it in the chart.

As for the functions - check the QlikView Reference Manual

http://community.qlik.com/docs/DOC-1794

Kind regards

[Jason_Michaelides]

Hi Rohitkoul,

Sorry for the delay - been out of town.  I think the attached does what you want.

Expression 1 (Sum) = Sum(Value)

Expression 2 (Accum) = Aggr(RangeSum(Above(Sum(Value),0,RowNo())),Year,Month)

Expression 3 (Div) = Accum/MonthNum

Hope this helps,

Jason