Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Jesh19
Creator II
Creator II

Listbox to show maximum date in each month selection

Hi All,

I have a requirement where my Reporting Date should pick Max(Reporting Date) for each month selection.

By default, my app shows Max(Reporting Date), but when I select any specific month, my selections are going off on Reporting Date.

NOTE: Reporting Date is shown using Calendar Object.

For ex: When I open my application, it would be defaulted to Max(Reporting Date) i.e., 15/11/2020, but when I select Oct in Month, I don't see any value selected in calendar object, it should show 31/10/2020

For Sep, 30/09/2020...Aug, 31/8/2020

Can someone please help me with the issue.

Thanking in Advance.

Jesh

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

HI @Jesh19 

You need to assign trigger for that in Document properties -> Triggers

MayilVahanan_0-1605685124310.png

MayilVahanan_1-1605685188779.png

 

Change the date field and provide the date format based on ur data.

Thanks & Regards,
Mayil Vahanan R

View solution in original post

2 Replies
MayilVahanan

HI @Jesh19 

You need to assign trigger for that in Document properties -> Triggers

MayilVahanan_0-1605685124310.png

MayilVahanan_1-1605685188779.png

 

Change the date field and provide the date format based on ur data.

Thanks & Regards,
Mayil Vahanan R
Jesh19
Creator II
Creator II
Author

Thanks for your help @MayilVahanan  😊