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

[#1]

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

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

for example

      if i select apr, may, Jun, Jul then it shows the jul 31st closing balance

     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

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

[IAMDV]

Vignesh,

What are your dimensions? Please can you post the sample app? And what do you have in vDashboardMaxDate? I'm assuming that you are using Month & Year as dimension...Is this right?

Cheers,

DV

www.QlikShare.com

[#3]

Deepak,

I have attached a sample document, right now am not able to

send app, Yes month is a dimension.

Regards

Vignesh

On Wed, Aug 1, 2012 at 12:17 PM, Deepak Vadithala <

[IAMDV]

Vignesh - What is the variable content/expression in vDashboardMaxDate?

Cheers,

DV

www.QlikShare.com

[#5]

DV - vDashboardMaxDate = Num(max(Select_Date))

Regards

Vignesh

On Wed, Aug 1, 2012 at 3:03 PM, Deepak Vadithala <

[#6]

The set analysis is computed for the whole chart, not for each line of the chart.

If you use a filter on "A_dimension" in your Set Analysis and your chart uses "A_dimension" as dimension, you set analysis wont be calculated for each value of "A_dimension" but for all your graph.

Use instead a "if" statement.