topic Re: defaut filter on selection max month in QlikView

defaut filter on selection max month

soniasweety — Sat, 16 Nov 2024 02:26:34 GMT

Hi All,

@Vegar , @sunny_talwar

i have attached sample based on each region selection that perticular max month should be selected.

AMS 201607

APJ 201707

EMEA 201707

whenever use select in region filed that perticular region max month should selected .

Re: defaut filter on selection max month

anat — Thu, 19 Sep 2019 06:57:17 GMT

we can apply Field Event Trigger to implement this scenario.

Settings...>Triggers....>Field Event Triggers

under this select "REGION" field and apply "On select " action

Select in Field

Field Name:New

search String:=max(New)

Re: defaut filter on selection max month

Arthur_Fong — Thu, 19 Sep 2019 07:03:05 GMT

Try this:

On Settings > Document Properties > Triggers > Field Event Triggers > OnSelect >Add Action >max([Date Field]).

Refer qvw attached for reference.

Thanks and regards,

Arthur Fong

Re: defaut filter on selection max month

sugathirajkumar — Thu, 19 Sep 2019 08:01:50 GMT

Take this as Date in list box =if(GetFieldSelections(Field)='AMS',(aggr(max(Date),Field)), if(GetFieldSelections(Field)='APJ',(aggr(max(Date),Field)), if(GetFieldSelections(Field)='EMEA',(aggr(max(Date),Field)),Date))) Fiel in another list box

Re: defaut filter on selection max month

sugathirajkumar — Thu, 19 Sep 2019 08:09:07 GMT

Re: defaut filter on selection max month

soniasweety — Thu, 19 Sep 2019 08:55:31 GMT

if i use this condition i can see only one month in the field. but i want t see all the months and max month to be selected.

Re: defaut filter on selection max month

Brett_Bleess — Mon, 30 Sep 2019 18:42:05 GMT

Just going to put a comment on this to move it back up to the top to see if anyone else has any ideas since you did post your QVW...

Regards,
Brett

Re: defaut filter on selection max month

Frank_Hartmann — Mon, 30 Sep 2019 19:13:10 GMT

see attached qvw

hope this helps