Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis for max date value?

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

24 Replies
kavita25
Partner - Specialist
Partner - Specialist

Check the qvw

Not applicable
Author

Not aggregation

when we click on month dimension its showing correct only 

But By default means if i cleared everything  its showing max date i e 9/6/2015(Sep month) and value of that max date


I dont want like that. what i need is by default july (max date) - value (max date)

                                        aug(max date) - value(max date )

                                        Sep(max date) - Value(max date)

Not applicable
Author

Here is the sample qvw file and Excel

Can u do it in mine ?

I m not understanding from ur file

Thanks,

Soumya

kavita25
Partner - Specialist
Partner - Specialist

Check the file

Anonymous
Not applicable
Author

I donot see your file

maybe this way?

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