Max Date from each month should appear in my List box

[bharani8]

Hi Experts - Kindly find my qvw file.. I have date field ... What i need is.. I need a list box in which it should show only the last date of each month... and that should be converted to a Month name...

Eg., in Aug if we have 29th Aug 2017, 30th Aug 2017, 31st Aug 2017... in my list box it should show only 31st Aug and it should appear as Aug-2017

[Chanty4u]

try this

1) Using Calculated Dimension

Aggr(Max(DateField),Month)

[Chanty4u]

if in chart

Dim:Month

Exp: 

=if(date(max(MonthEnd(date))),Sales)

[bharani8]

can u show that in my qvw attached ?

[Chanty4u]

sorry i dont have license version of qlikview

[tresesco]

Change your timestamp format in the script so that your date gets converted to a number from text and then try listbox expression like:

SET TimestampFormat='M/D/YYYY h:mm[:ss.fff TT]';

=MonthName(If (Yday=Floor(MonthEnd(Yday)), Yday))

[bharani8]

Hi Tresesco - Thanks!! But i need the max date that is there in Sept till Dec month as well... For those months, if u see.. max sate will be not the last date of month..

[tresesco · Accepted solution]

Create a month field in the script and use expression like:

=MonthName(If (Yday=Aggr(Max(Yday),Month), Yday))

[bharani8]

Woww!! That was really quick response like a Tracer Bullet!!(As Ravi Shahstri says ) Thank u so much!! Gr8 day!

[bharani8]

Same logic when i try to apply in my dashboard, it is not working