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

[Jason_Michaelides]

Try this:

Hope this helps,

Jason

[#3]

Thanks jayson is there any other way?

[Jason_Michaelides]

I'm sure there is, but why?

[#5]

You can do this in the load script. Example:

Temp1:

LOAD * INLINE [

Month, Value

Apr, 10

May, 20

Jun, 30

Jul, 40

Aug, 50

];

Temp2:

NoConcatenate

LOAD

    Month,

    Value,

    if(isnull(peek('Sum')),0,peek('Sum'))+Value AS Sum

Resident Temp1;

Drop table Temp1;

[#6]

Hi Przemek,

Thanks i have tried that but it will give me a total aggregade data. i need to catagorise that for particular year Month Selection.....

i mean i need if i select a year it should start from that month of Year... but this will give me a overall Aggregade data

[Jason_Michaelides]

So why can't you use the Accumulation setting?

[#8]

Dear all,

This is what i exactly want..... last column which shud get divided by respective Month.....

[#9]

Hi

I don't know how you get the number in the yellow column. If the calcaultions are done as is stated in the header than the numbers are wrong. Your output look fine to me.

[#10]

Its just Column (4) divided by Column (1) that is in short i need to divide [Acc Data] by its respective Month.

But in Qlikview its not taking Column (4) data which is selected as  Accumulated in Front end.. Rather its taking the real values which are in Column (3).

I have attached the QVW file Which Might help you to understand my Problem