Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Whats wrong with this?

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

Ma

9 Replies
brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

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

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

Greetings from Munich

erichshiino
Partner - Master
Partner - Master

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

or

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

Regards,

Erich

Not applicable
Author

Hi,

Can you pls try using the following:

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

Regards

Arun

Not applicable
Author

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,

Not applicable
Author

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

brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

you need the function before resp. above

Not applicable
Author

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

Not applicable
Author

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,

Not applicable
Author

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