Setanalysis

[#1]

Hi Everyone,

How to get the month end Account Balance by using setanalysis.

like i need to to show

1)month end account balance (only month end day)

2)last month month end date account balance

Thanks

[Anil_Babu_Samineni]

Here you go,

1.1) Create one field like

    if(monthend(TransactionDate) = TransactionDate, 1,0) as MonthEnd_Flag

1.2) Please use Set analysis like below

    Sum({<MonthEnd_Flag = {1}>} Amount)

2) For your second requirement, Use below

    Sum({<MonthEnd_Flag = {1}, Month = {'$(=AddMonths(Max(Month),-1))'}>} Amount)

[prma7799]

Please check ...

Set analysis and set expressions ‒ QlikView

[Anonymous]

Hi,

1)month end account balance (only month end day)

for this Requirement,

first derive the month end dates by using your date field and

then you can use this month end filed and you can use the sum of  account balance filed as expression on chart

it will gives the month end date wise account balances.

any by this you can also see the every month end date account balance.

Thanq.