topic Aggregated Data in QlikView

Aggregated Data

Tue, 31 Jan 2012 14:19:35 GMT

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

Aggregated Data

Jason_Michaelides — Tue, 31 Jan 2012 14:46:03 GMT

Try this:

Hope this helps,

Jason

Aggregated Data

Tue, 31 Jan 2012 14:49:19 GMT

Thanks jayson is there any other way?

Aggregated Data

Jason_Michaelides — Tue, 31 Jan 2012 14:50:13 GMT

I'm sure there is, but why?

Re: Aggregated Data

Tue, 31 Jan 2012 14:51:18 GMT

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;

Aggregated Data

Tue, 31 Jan 2012 15:01:58 GMT

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

Aggregated Data

Jason_Michaelides — Tue, 31 Jan 2012 15:23:07 GMT

So why can't you use the Accumulation setting?

Aggregated Data

Tue, 31 Jan 2012 15:58:03 GMT

Dear all,

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

Aggregated Data

Wed, 01 Feb 2012 08:41:11 GMT

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.

Re: Aggregated Data

Wed, 01 Feb 2012 13:22:47 GMT

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

Aggregated Data

Wed, 01 Feb 2012 13:26:32 GMT

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.

Re: Aggregated Data

Wed, 01 Feb 2012 13:30:19 GMT

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 ....

Re: Aggregated Data

Wed, 01 Feb 2012 14:43:05 GMT

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).

Re: Aggregated Data

Thu, 02 Feb 2012 04:55:24 GMT

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 ......

Re: Aggregated Data

Thu, 02 Feb 2012 05:38:57 GMT

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 ....

Re: Aggregated Data

Thu, 02 Feb 2012 09:16:14 GMT

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

Re: Aggregated Data

Jason_Michaelides — Thu, 02 Feb 2012 09:21:03 GMT

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