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]

We have 4 columns

Month,Week , Date  and some metric

i tried this way

=Sum({<Date = {"$(max(date))"}>}listing_count)

But its not working

Can anyone help me out of this?

[Anonymous]

one is Date, other is date

next "=" is missing

Date is an inbuilt function, rename your fieldnames myDate instead of Date

wrong: =Sum({<Date = {"$(max(date))"}>}listing_count)

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

[settu_periasamy]

Hi,

Field value is case sensitive. check your field date or Date

You can try

=Sum({<Date = {'$(=max(Date))'}>}listing_count)

[jonathandienst]

Firstly - QV field names are case sensitve, so the fields date and Date are two distinct fields, which I assume is not your intention. Assuming the field name is "date" and that "date" is a proper QV date value and is formatted in your default date format:

=Sum({<date = {"$(=Date(max(date)))"}>} listing_count)

[#6]

Actually its Date only

Type  mistake

[settu_periasamy]

May be you can try with date format..

like

=Sum({<Date = {'$(=Date(max(Date)))'}>}listing_count)

or

=Sum({<Date = {'$(=Date(max(Date)),YourDateFieldFormat)'}>}listing_count)

[#8]

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

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

I want Number for all the months

Thanks,

Soumya

[#9]

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

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

I want Number for all the months

Thanks,

Soumya

[Anonymous]

I donot understand with your origin Statement that you Need max date?

does that mean if I select August you want complet August, if I select Jun-Aug

you want data from 1.6.-31.8?

you would not Need set Analysis as you select the months you require

sum(listing_Count)

if you Need complet range you may use this

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