Select max date automatically by selecting year and month

[viveksingh]

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.

[viveksingh]

Any help on this please

[Nikhith]

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],'[]'))

[Nikhith]

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],'[]'))

[viveksingh]

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

[viveksingh]

Any help on this please