topic Re: Problem with using alternate state in QlikView https://community.qlik.com/t5/QlikView/Problem-with-using-alternate-state/m-p/941862#M467353 <HTML><HEAD></HEAD><BODY><P>It's what i need!</P><P>Thx.</P></BODY></HTML> Thu, 19 Nov 2015 14:31:29 GMT Anonymous 2015-11-19T14:31:29Z Problem with using alternate state https://community.qlik.com/t5/QlikView/Problem-with-using-alternate-state/m-p/941859#M467350 <HTML><HEAD></HEAD><BODY><P>Good day!</P><P>In my model i have several pivot tables with different alternate states. (They're described on attached picture.<SPAN style="font-size: 10pt; line-height: 1.5em;">)</SPAN></P><P></P><P>Also i have one list box wtih default state. All of my pivots must be invisible when i choose "For brand managers".</P><P>Because of different alternate state show object condition doesn't work.</P><P></P><P>Please, help to solve this problem (with keeping these alternate states)</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 19 Nov 2015 12:58:44 GMT https://community.qlik.com/t5/QlikView/Problem-with-using-alternate-state/m-p/941859#M467350 Anonymous 2015-11-19T12:58:44Z Re: Problem with using alternate state https://community.qlik.com/t5/QlikView/Problem-with-using-alternate-state/m-p/941860#M467351 <HTML><HEAD></HEAD><BODY><P>Try a show condition in the pivot tables like</P><P></P><P>=Match( Only( {$} <EM>ListBoxField</EM>), 'For sales team') =1</P><P></P><P>Replace ListBoxField with the appropriate field name.</P></BODY></HTML> Thu, 19 Nov 2015 14:11:02 GMT https://community.qlik.com/t5/QlikView/Problem-with-using-alternate-state/m-p/941860#M467351 swuehl 2015-11-19T14:11:02Z Re: Problem with using alternate state https://community.qlik.com/t5/QlikView/Problem-with-using-alternate-state/m-p/941861#M467352 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>May be try this...In the Chart Layout -&gt; Conditional Show</P><P></P><P><STRONG>=GetSelectedCount(YourListBoxField)&gt;0 and<SPAN style="font-size: 10pt; line-height: 1.5em;">WildMatch(GetFieldSelections(YourListBoxField),'</SPAN><SPAN style="line-height: 1.5em; color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">For brand managers</SPAN></STRONG><SPAN style="font-size: 10pt; line-height: 1.5em;"><STRONG>')</STRONG></SPAN></P></BODY></HTML> Thu, 19 Nov 2015 14:13:54 GMT https://community.qlik.com/t5/QlikView/Problem-with-using-alternate-state/m-p/941861#M467352 settu_periasamy 2015-11-19T14:13:54Z Re: Problem with using alternate state https://community.qlik.com/t5/QlikView/Problem-with-using-alternate-state/m-p/941862#M467353 <HTML><HEAD></HEAD><BODY><P>It's what i need!</P><P>Thx.</P></BODY></HTML> Thu, 19 Nov 2015 14:31:29 GMT https://community.qlik.com/t5/QlikView/Problem-with-using-alternate-state/m-p/941862#M467353 Anonymous 2015-11-19T14:31:29Z