Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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
Partner

Hi,

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

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

Greetings from Munich

erich_shiino
Partner
Partner

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
Partner

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