topic Re: Select max date automatically by selecting year and month in QlikView

Select max date automatically by selecting year and month

viveksingh — Wed, 25 Nov 2020 16:16:04 GMT

Hi expersts,
I have filters like year, month. When user selects year, month then it should automatically select maximum date of the month based on year in qlikview.

Re: Select max date automatically by selecting year and month

viveksingh — Fri, 18 Jan 2019 05:45:49 GMT

Any help on this please

Re: Select max date automatically by selecting year and month

Nikhith — Fri, 18 Jan 2019 06:52:33 GMT

Hi,

i'd suggest fixing your date load in the load script . otherwise the trigger needs to invoke the same purgechar() expression.

Here is a working example of the select in field action WITHOUT fixing the load script:

max( {1} PurgeChar([Day-Month],'[]'))

Re: Select max date automatically by selecting year and month

viveksingh — Tue, 22 Jan 2019 01:58:37 GMT

Here month is a filter. Once month is selected, it should automatically select max date

Re: Select max date automatically by selecting year and month

viveksingh — Tue, 22 Jan 2019 07:45:12 GMT

Any help on this please