topic How to one field selection can affect another filter? in QlikView https://community.qlik.com/t5/QlikView/How-to-one-field-selection-can-affect-another-filter/m-p/547953#M204698 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I need your help again. The question is: if I select reportName 'Fifth' from filter, the Year filter automatically must show max(Year) - 2013&nbsp; from filter and deselect another fields - Quarter, Month, Day. Should I write macros on select field or do something another? I don't know how to write it. Could you please help me. Thank you very much. Example is attached.</P></BODY></HTML> Thu, 01 Aug 2013 09:02:08 GMT 2013-08-01T09:02:08Z How to one field selection can affect another filter? https://community.qlik.com/t5/QlikView/How-to-one-field-selection-can-affect-another-filter/m-p/547953#M204698 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I need your help again. The question is: if I select reportName 'Fifth' from filter, the Year filter automatically must show max(Year) - 2013&nbsp; from filter and deselect another fields - Quarter, Month, Day. Should I write macros on select field or do something another? I don't know how to write it. Could you please help me. Thank you very much. Example is attached.</P></BODY></HTML> Thu, 01 Aug 2013 09:02:08 GMT https://community.qlik.com/t5/QlikView/How-to-one-field-selection-can-affect-another-filter/m-p/547953#M204698 2013-08-01T09:02:08Z Re: How to one field selection can affect another filter? https://community.qlik.com/t5/QlikView/How-to-one-field-selection-can-affect-another-filter/m-p/547954#M204699 <HTML><HEAD></HEAD><BODY><P>Is this what you want?</P></BODY></HTML> Thu, 01 Aug 2013 09:15:19 GMT https://community.qlik.com/t5/QlikView/How-to-one-field-selection-can-affect-another-filter/m-p/547954#M204699 2013-08-01T09:15:19Z Re: How to one field selection can affect another filter? https://community.qlik.com/t5/QlikView/How-to-one-field-selection-can-affect-another-filter/m-p/547955#M204700 <HTML><HEAD></HEAD><BODY><P>I would like that max(Year) will be default value for this report, but also have to be opportunity to select only one another Year value, and filters - <SPAN style="color: #737373; font-family: Arial; font-size: 12.727272033691406px; background-color: #ffffff;">Quarter, Month, Day </SPAN>have to be deactivated for this report.</P></BODY></HTML> Thu, 01 Aug 2013 10:16:27 GMT https://community.qlik.com/t5/QlikView/How-to-one-field-selection-can-affect-another-filter/m-p/547955#M204700 2013-08-01T10:16:27Z