topic Re: Unwanted selection when using expression in Multi Box in QlikView https://community.qlik.com/t5/QlikView/Unwanted-selection-when-using-expression-in-Multi-Box/m-p/507776#M1146992 <HTML><HEAD></HEAD><BODY><P>The easiest way would be to create another field with the same filter in your data model, then use this field in the multi-box.</P></BODY></HTML> Tue, 20 Aug 2013 14:43:14 GMT swuehl 2013-08-20T14:43:14Z Unwanted selection when using expression in Multi Box https://community.qlik.com/t5/QlikView/Unwanted-selection-when-using-expression-in-Multi-Box/m-p/507775#M1146991 <HTML><HEAD></HEAD><BODY><P>I have a problem when filtering my Multi Box to only show the dates for which I have data in a specific field. The expression I am using is this:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13770091709415832" jivemacro_uid="_13770091709415832"> <P>=if( not IsNull([Värde SO-historik]), Datum )</P> </PRE><P></P><P>The result is what I want - now only the relevant dates are shown:</P><P><IMG alt="Multi Box.jpg" class="jive-image" src="/legacyfs/online/45733_Multi Box.jpg" /></P><P></P><P>However, when selecting a date I also get a selection in the field I used in the above condition:</P><P><IMG alt="Selected.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/45738_Selected.jpg" /></P><P>This is undesirable. How can I make it so that no selection is made in the field "Värde SO-historik"?</P></BODY></HTML> Tue, 20 Aug 2013 14:39:22 GMT https://community.qlik.com/t5/QlikView/Unwanted-selection-when-using-expression-in-Multi-Box/m-p/507775#M1146991 2013-08-20T14:39:22Z Re: Unwanted selection when using expression in Multi Box https://community.qlik.com/t5/QlikView/Unwanted-selection-when-using-expression-in-Multi-Box/m-p/507776#M1146992 <HTML><HEAD></HEAD><BODY><P>The easiest way would be to create another field with the same filter in your data model, then use this field in the multi-box.</P></BODY></HTML> Tue, 20 Aug 2013 14:43:14 GMT https://community.qlik.com/t5/QlikView/Unwanted-selection-when-using-expression-in-Multi-Box/m-p/507776#M1146992 swuehl 2013-08-20T14:43:14Z Re: Unwanted selection when using expression in Multi Box https://community.qlik.com/t5/QlikView/Unwanted-selection-when-using-expression-in-Multi-Box/m-p/507777#M1146993 <HTML><HEAD></HEAD><BODY><P>Hi, thanks for the prompt answer!</P><P>This is actually how I have currently solved it, but I wanted to use the field "datum" so that a selection here will be meaningful also for other tabs and charts in my app (it is quite big with 9 tabs - one for each KPI - and the specified field should optimally be relevant for all the tabs).</P></BODY></HTML> Tue, 20 Aug 2013 14:49:27 GMT https://community.qlik.com/t5/QlikView/Unwanted-selection-when-using-expression-in-Multi-Box/m-p/507777#M1146993 2013-08-20T14:49:27Z Re: Unwanted selection when using expression in Multi Box https://community.qlik.com/t5/QlikView/Unwanted-selection-when-using-expression-in-Multi-Box/m-p/507778#M1146994 <HTML><HEAD></HEAD><BODY><P>Try something like</P><P></P><P>=aggr( if( not only({1} IsNull([Värde SO-historik])), only({1}Datum) ), Datum)&nbsp; </P></BODY></HTML> Tue, 20 Aug 2013 15:00:29 GMT https://community.qlik.com/t5/QlikView/Unwanted-selection-when-using-expression-in-Multi-Box/m-p/507778#M1146994 swuehl 2013-08-20T15:00:29Z