Set analysis for max date value?

[#1]

There is month name and week name for each date. when i select month i need the value for max date.

Ex- For August i need the value for max date(i.e 31st August)  as in database

Thanks in advance,

Soumya

[#2]

If i dont do any selection it  shows metric number for only the max date

i want the metric number for all the months

[#3]

If i dont do any selection it  shows metric number for only the max date

i want the metric number for all the months

[Anonymous]

an you post sample qvw?

[#5]

For example i have date for july ,august and sep

if i dont selection any of these 3 months it showing the metric value for max date of sep month

But i want metric value for all the 3 months

[#6]

Here is the sample file

[Anonymous]

can you please test with a textobject?

insert: = min(mydate) & '-' & max(mydate)

if july, August and sep are shown inwhite (=available) in a listbox the formula should Show the amount

forumla was not correct, did Show error, this forumla works in my example

sum({<myDate={">=$(=min(myDate))<=$(=max(myDate))"}>}listing_Count)

[#8]

But  your expression gives wrong data

sum({$<my_date={"$(=max(my_date))"}>}Metric) this expression gives me correct answer

  in this above expression if i don't select anything its giving me sep 6   and the metric value 375

But i want July  - metric value

                   August - metric value

                  Sep - metric value

[sasiparupudi1]

his code is working but if i do the selection then it shows only the max date i.e august

What selections are you talking about?

The max(my_date) returning 375 as metric  for 9/6/2015

[#10]

Correct by default its showing max date i e 9/6/2015 and the value is 375

But  by default i need  july (max date) - value (31st)

                                        aug(max date) - value(29th )

                                        Sep(max date) - Value(6th)

[Anonymous · Accepted solution]

to clarify: you have data from different months. you Need fromeach month the value frommax(date) withinthat month?

then aggr function might be helpful (i am not sure if Syntax is correct)

aggr(sum({$<my_date={"$(=max(my_date))"}>}Metric),my_date)