# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Not applicable

## how to get average balance of month in qlikview

this Expression give me Current balance now how to get average balance of month for on Year

num(SUM( {<

[FinMonth] =

{"<=\$(max(FinMonth))"},

[FinQuarterNum] =

{"<=\$(max(FinQuarterNum))"},

[FinYear] =

{"<=\$(vMaxYear)"}

>} (InFlowUnits-OutFlowsUnits)*nav_value) ,' #,##0 ')

Thanxs Regards,

Usman

8 Replies
Highlighted
MVP

Try replacing sum() by avg().

Highlighted
Not applicable

Hi,

Num(Avg( {<

[FinMonth] ={"<=\$(max(FinMonth))"},

[FinQuarterNum] ={"<=\$(max(FinQuarterNum))"},

[FinYear] ={"<=\$(vMaxYear)"}

>} (InFlowUnits-OutFlowsUnits)*nav_value) )

Hope it helps you.

Thanks and Regards,

S.Amuthabharathi

Highlighted
Not applicable

Still Not Correct result . can u tell me how to get 12 month balance and then sum for example

1:100, sum(month)

2:100,sum(month)

3:300,sum(month)

4:100,sum(month)

5:100,sum(month)

6:200,sum(month)

7:100,sum(month)

8:300,sum(month)

9:400,sum(month)

10:400,sum(month)

11:100,sum(month)

12:200 sum(month)

then sum(all months)

sum(sum(month)) i want to do like this. how its possible?

Highlighted
MVP

You can try something like:

Aggr(Sum({Your set expression} Expression), Month)    // to get monthly sums

I still doubt what you excatly need. Can you share a sample app?

Highlighted
Specialist

Hi

Try like this

Here FinalDate is ur datefield

= Num(Avg({<FinalDate = ">=\$(=YearStart(max(FinalDate)))<=\$(=max(FinalDate))">}(InFlowUnits-OutFlowsUnits)*nav_value),'#,##0.00')

Regards,

Highlighted
Not applicable

tresesco

exactly i want to do

average balance month = sum(balance for month of every day )/noof transaction

this expression give me current Balance.

num(SUM( {<

[FinMonth] =

{"<=\$(max(FinMonth))"},

[FinQuarterNum] =

{"<=\$(max(FinQuarterNum))"},

[FinYear] =

{"<=\$(vMaxYear)"}

>} (InFlowUnits-OutFlowsUnits)*nav_value) ,' #,##0 ')

how to create balancing for 30 day of selected month

Regards,

Usman

Highlighted
Not applicable

exactly i want to do

average balance month = sum(balance for month of every day )/noof transaction

this expression give me current Balance.

num(SUM( {<

[FinMonth] =

{"<=\$(max(FinMonth))"},

[FinQuarterNum] =

{"<=\$(max(FinQuarterNum))"},

[FinYear] =

{"<=\$(vMaxYear)"}

>} (InFlowUnits-OutFlowsUnits)*nav_value) ,' #,##0 ')

how to create balancing for 30 day of selected month

Regards,

Usman

Highlighted
Specialist

Hi,

Restrict the Month and Quarter selection. It will give bal of select Month. i want to know transaction fields

= Sum({<[FinMonth] =,[FinQuarterNum] =,FinalDate = ">=\$(=MonthStart(max(FinalDate)))<=\$(=max(FinalDate))">}(InFlowUnits-OutFlowsUnits)*nav_value) / no of transaction

Regards,