topic Re: Automatic set values in other fields when select a value of another field in QlikView https://community.qlik.com/t5/QlikView/Automatic-set-values-in-other-fields-when-select-a-value-of/m-p/437817#M163231 <HTML><HEAD></HEAD><BODY><P>Thnx for your answer. But i am looking for the formula of such a trigger. I know i can use triggers</P></BODY></HTML> Mon, 19 Nov 2012 10:39:15 GMT francisvandergr 2012-11-19T10:39:15Z Automatic set values in other fields when select a value of another field https://community.qlik.com/t5/QlikView/Automatic-set-values-in-other-fields-when-select-a-value-of/m-p/437814#M163228 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I attached an qvw of what i want. It is an example with a few data.</P><P></P><P>What i want is when i select accounts or invoices also year 2012 is selected and no month<BR />When is select orders no year must be selected but only month Jan</P><P>How can i do this with a trigger ?</P></BODY></HTML> Tue, 25 Sep 2012 12:28:36 GMT https://community.qlik.com/t5/QlikView/Automatic-set-values-in-other-fields-when-select-a-value-of/m-p/437814#M163228 francisvandergr 2012-09-25T12:28:36Z Re: Automatic set values in other fields when select a value of another field https://community.qlik.com/t5/QlikView/Automatic-set-values-in-other-fields-when-select-a-value-of/m-p/437815#M163229 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>You can use 'OnSelect' trigger (Document properties-&gt;Triggers) for that fields with 'Select in Field' actions.</P></BODY></HTML> Tue, 25 Sep 2012 13:58:30 GMT https://community.qlik.com/t5/QlikView/Automatic-set-values-in-other-fields-when-select-a-value-of/m-p/437815#M163229 whiteline 2012-09-25T13:58:30Z Re: Automatic set values in other fields when select a value of another field https://community.qlik.com/t5/QlikView/Automatic-set-values-in-other-fields-when-select-a-value-of/m-p/437816#M163230 <HTML><HEAD></HEAD><BODY><P>Thnx for your answer. But i am looking for the formula of such a trigger. I know i can use triggers</P></BODY></HTML> Mon, 19 Nov 2012 10:38:59 GMT https://community.qlik.com/t5/QlikView/Automatic-set-values-in-other-fields-when-select-a-value-of/m-p/437816#M163230 francisvandergr 2012-11-19T10:38:59Z Re: Automatic set values in other fields when select a value of another field https://community.qlik.com/t5/QlikView/Automatic-set-values-in-other-fields-when-select-a-value-of/m-p/437817#M163231 <HTML><HEAD></HEAD><BODY><P>Thnx for your answer. But i am looking for the formula of such a trigger. I know i can use triggers</P></BODY></HTML> Mon, 19 Nov 2012 10:39:15 GMT https://community.qlik.com/t5/QlikView/Automatic-set-values-in-other-fields-when-select-a-value-of/m-p/437817#M163231 francisvandergr 2012-11-19T10:39:15Z Re: Automatic set values in other fields when select a value of another field https://community.qlik.com/t5/QlikView/Automatic-set-values-in-other-fields-when-select-a-value-of/m-p/437818#M163232 <HTML><HEAD></HEAD><BODY><P>If you just want to make an expression that calculates as if year 2012 is selected when you select account, you could use set analysis feature.</P></BODY></HTML> Mon, 19 Nov 2012 16:38:43 GMT https://community.qlik.com/t5/QlikView/Automatic-set-values-in-other-fields-when-select-a-value-of/m-p/437818#M163232 whiteline 2012-11-19T16:38:43Z