topic Whats wrong with this? in QlikView

Whats wrong with this?

Wed, 22 Jun 2011 12:51:34 GMT

Hello Experts,

I have an expression in a Pivot chart with Year Month Dimension as below, it doesnt work and I am unable to find the issue with this:

I am trying to aggregate the monthly values for Year To Date numbers, which are stored in variables as seen here.

=AGGR($(vActPrinCashFlowC)+$(vActIntCashFlowC),Calendar.YearMonth)

Thanks in Advance for your help

Whats wrong with this?

brenner_martina — Wed, 22 Jun 2011 12:55:24 GMT

Hi,

is it possible, that you want to sum the values? than try this:

=Sum(AGGR(($(vActPrinCashFlowC)+$(vActIntCashFlowC)),Calendar.YearMonth))

Greetings from Munich

Whats wrong with this?

erichshiino — Wed, 22 Jun 2011 12:56:58 GMT

Aggr will only group information by the dimensions you choose.

You need to do something with the results.

E.g.

sum(AGGR($(vActPrinCashFlowC)+$(vActIntCashFlowC),Calendar.YearMonth))

avg( AGGR($(vActPrinCashFlowC)+$(vActIntCashFlowC),Calendar.YearMonth))

Regards,

Erich

Re: Whats wrong with this?

Wed, 22 Jun 2011 13:02:57 GMT

Hi,

Can you pls try using the following:

=AGGR(sum($(vActPrinCashFlowC))+sum($(vActIntCashFlowC)),Calendar.YearMonth)

Regards

Arun

Whats wrong with this?

Wed, 22 Jun 2011 13:09:41 GMT

Hello All,

Thank you for the quick response, I was actually trying the same expression as mentioned by all of you here. But the problem is the 2 variables when combined give me a number and its the same even when I am doing the AGGR.

$(vActPrinCashFlowC)+$(vActIntCashFlowC)

sum(AGGR($(vActPrinCashFlowC)+$(vActIntCashFlowC),Calendar.YearMonth))

Both these expressions when used on a Pivot with Calendar.YearMonth as dimension gives me the same result. I was expecting the second one to display the carryforwarded totals from the last month. The first expression shows me the number for the Moth to Date collection and I want the second one to total it and shows Year To Date... How is it possible??

Thanks Again,

Whats wrong with this?

Wed, 22 Jun 2011 13:18:09 GMT

Hello Arunraj,

I tried this expression as well, but it doesnt seem to work atall...

Here is what I am trying to do:

$(vActPrinCashFlowC)+$(vActIntCashFlowC) Using this expression gives me

2011-01 20,000

2011-02 33,000

2011-03 41,000

sum(AGGR($(vActPrinCashFlowC)+$(vActIntCashFlowC),Calendar.YearMonth)) Using this expression I want to

2011-01 20,000

2011-02 53,000

2011-03 94,000

I thought AGGR does it for me... but no...please help

Thanks

Whats wrong with this?

brenner_martina — Wed, 22 Jun 2011 13:45:55 GMT

Hi,

you need the function before resp. above

Whats wrong with this?

Wed, 22 Jun 2011 14:01:25 GMT

Hello Martina,

I tried all the above expressions and nothing works for me. The strange thing is that when i convert my Pivot into a Bar chart to check i the Full Accumlation works... then its solves my problem. Can you tell me how to do a FULL ACCUMLATE of values in a Pivot please?

Thanks Again

Whats wrong with this?

Wed, 22 Jun 2011 14:50:42 GMT

Hello All,

Do we have an option to do a full Accumlate on a Pivot table like we can do it in Straight Table and other Charts??/

Thanks in Advance,

Whats wrong with this?

Thu, 23 Jun 2011 01:10:38 GMT

Above and Below are the comparable functions within a pivot table, used with rangesum I believe it will get you on your way, here is a brief example, just replace Sales with your variables.

rangesum (sum(Sales),below(sum(Sales),-1,11))