Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to find a max date of each months balance value ???

How to find a max date of each months balance value ???

I used the below expression through this i can get only the max of selected month date balance only

for example

      if i select apr, may, Jun, Jul then it shows the jul 31st closing balance of all apr may jun and jul months but i

expect  

    Apr      6257.11

    May    6257.11

    Jun     6257.11

     Jul      6257.11

But expected result is

    Apr     5259.15

    May    7256.38

    Jun     5930.41

    Jul      6257.11

the expression i used is

=sum({<Num_Trx_Date={'<=$(=num(vDashboardMaxDate))'},AMISDETAILID={'10022000012879'},YearEnd_Flag={'Without Year End'}>}BS_Amount*Flag)/$(vDiv)

1 Reply
Not applicable

Re: How to find a max date of each months balance value ???

Hi,

Just Aggregate it by month..So that it will take the Max date for each month and will sove your problem.

Sum(Aggr(

sum({<Num_Trx_Date={'<=$(=num(vDashboardMaxDate))'},AMISDETAILID={'10022000012879'},YearEnd_Flag={'Without Year End'}>}BS_Amount*Flag)/$(vDiv)

,Month

))

Regards,

Desmortes

Community Browser