Qlik Community

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 
Search instead 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
MVP

Try replacing sum() by avg().

Highlighted
Not applicable

Hi,

Please try this

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