Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
MK_QSL
MVP
MVP

Max Day of Max Month

For the enclosed file, when I open the Main Tab, I need the Maximum Day of Maximum Month to be selected by trigger.

I don't want to use Date Field here...

i.e. Max(Date) ...

I need something like

Max Day where Month = Max Month....

Hope I have explained clearly...

10 Replies
Not applicable

Why does Max(Date) not work for you? It seems to get the job done.. Max Date will select Max Month and Max Day as well.

MK_QSL
MVP
MVP
Author

It's working... but I want another way...Just for my curiosity...

Let's consider that the calendar is from 01/01/2014 to 28/12/2014...

I need the selection on Day should be 28 when I open the document.

Not applicable

I think that would happen, since each there is only one day associated with each date?

erich_shiino
Partner
Partner

Hi,

I created a version of your qvw with a new field and a new action to accomplished what you wanted.

Best Regards,

Erich

MK_QSL
MVP
MVP
Author

Already said in my question....

I don't want to use Date Field here...

jagannalla
Partner
Partner

Hi,

Please find the attachment.

Thanks,

Jagan

MK_QSL
MVP
MVP
Author

Thanks Jagan,.... But you also have used (indirectly) my Date Field....

I want this to be achieved using

Day and Month field only....

bruno_montenegr
Creator III
Creator III

Hello, Manish.

Using the Date filed would be easier, but it seems it is not available in your app. Then, you could use these two expressions to select Month and Day respectively:

=Month(MakeDate(1, Max(Month), 1))

=Max({$<Month = {$(=Month(MakeDate(1, Max(Month), 1)))}>} Day)

Attached is a QVW with your calendar modified to go only until December 28 and selecting the appropriate fields when opened.

Cheers.

jagannalla
Partner
Partner

Manish - Use any number there like 0 or 1 or 0000 etc

=Month(MakeDate(1,Max(Month)))

=Max({<Month = {'$(=Month(MakeDate(1,Max(Month))))'}>}Day)