Syntax of Average monthly balance

[#1]

Hi,

I am interested in knowing the syntax in the below given given sceario:

A) I have one table with Daily PnL balances for different emerging economies at client level for one year.

B) Daily PnL Balance is an expression which is simply a sum of PnL of different clients.

C) I have to get average monthly PnL balance.

How do I go about forming the syntax in my Daily PnL expression incorporating the average to be taken monthly using the daily data in the table?

Let me know if any more clarity is needed in my question here.

Thanks

[ashfaq_haseeb]

Hi,

Below document will give you a better start.

http://community.qlik.com/docs/DOC-3324

Regards

ASHFAQ

[#3]

try:

month as dimension

avg(aggr(sum(balance),date))

//where as month, date and balance put your adequate fields.

[#4]

How do I break the months using thr dates in my expression formula?

[#5]

?