topic Multibox: Expressions in QlikView https://community.qlik.com/t5/QlikView/Multibox-Expressions/m-p/574562#M1111118 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>If you refer to the below grid</P><P><IMG alt="Untitled1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/53871_Untitled1.png" /></P><P>My intention is to get a dynamic filter, if I select Business Grp as A then I should get filter of variable A which should show only A1</P><P>else I should get filter of variable B with only B2 value in the drop down.</P><P>I am trying to write an expression within a multibox :</P><P><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Business Grp]</SPAN><SPAN style="font-size: 8pt;">='A',</SPAN><SPAN style="color: #800000; font-size: 8pt;">A</SPAN><SPAN style="font-size: 8pt;">='A1',</SPAN><SPAN style="color: #800000; font-size: 8pt;">B='B1'</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P>I am getting -1 and 0 value in a filter drop down.</P><P>Does anybody has idea about it?</P><P></P><P>Kind Regards,</P><P>Varun</P></BODY></HTML> Wed, 26 Feb 2014 15:57:52 GMT 2014-02-26T15:57:52Z Multibox: Expressions https://community.qlik.com/t5/QlikView/Multibox-Expressions/m-p/574562#M1111118 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>If you refer to the below grid</P><P><IMG alt="Untitled1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/53871_Untitled1.png" /></P><P>My intention is to get a dynamic filter, if I select Business Grp as A then I should get filter of variable A which should show only A1</P><P>else I should get filter of variable B with only B2 value in the drop down.</P><P>I am trying to write an expression within a multibox :</P><P><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Business Grp]</SPAN><SPAN style="font-size: 8pt;">='A',</SPAN><SPAN style="color: #800000; font-size: 8pt;">A</SPAN><SPAN style="font-size: 8pt;">='A1',</SPAN><SPAN style="color: #800000; font-size: 8pt;">B='B1'</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P>I am getting -1 and 0 value in a filter drop down.</P><P>Does anybody has idea about it?</P><P></P><P>Kind Regards,</P><P>Varun</P></BODY></HTML> Wed, 26 Feb 2014 15:57:52 GMT https://community.qlik.com/t5/QlikView/Multibox-Expressions/m-p/574562#M1111118 2014-02-26T15:57:52Z