topic Re: Disappearing Conditional Expressions in straight table... in QlikView https://community.qlik.com/t5/QlikView/Disappearing-Conditional-Expressions-in-straight-table/m-p/1254606#M517835 <HTML><HEAD></HEAD><BODY><P>Read about the parameters within GetFieldSelections here: <A href="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/FieldFunctions/getfieldselections.htm" title="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/FieldFunctions/getfieldselections.htm">GetFieldSelections ‒ QlikView</A></P></BODY></HTML> Tue, 13 Dec 2016 16:30:11 GMT sunny_talwar 2016-12-13T16:30:11Z Disappearing Conditional Expressions in straight table... https://community.qlik.com/t5/QlikView/Disappearing-Conditional-Expressions-in-straight-table/m-p/1254604#M517833 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have been working on an 'ad hoc' report builder in Qlikview.&nbsp; It is a straight table with 17 different Conditional Expressions which are switched on and off using a list box based on an inline table.&nbsp; When I have more than 6 options selected from the listbox, the conditional columns in my straight table all disappear.&nbsp; I have already set my user preferences for 'Max Values in Current Selection Box' to 99 so I know this isn't the problem</P><P></P><P>This is the format criteria I am using for each conditional expression - REPORT_CRITERIA_E_DESC stays the same for all with the field value changing for each of the 17 options</P><P></P><P> <SPAN style="font-size: 12pt;"><SPAN style="color: #0000ff;">index</SPAN>(<SPAN style="color: #0000ff;">GetFieldSelections</SPAN>(<SPAN style="color: #800000;">REPORT_CRITERIA_E_DESC</SPAN>),'Regulation Exceptions')&gt;0 </SPAN></P><P></P><P><SPAN style="font-size: 12pt;">Any help would be very much appreciated!</SPAN></P><P></P><P><SPAN style="font-size: 12pt;">Thank you</SPAN></P></BODY></HTML> Tue, 13 Dec 2016 12:48:31 GMT https://community.qlik.com/t5/QlikView/Disappearing-Conditional-Expressions-in-straight-table/m-p/1254604#M517833 siobhancrossen 2016-12-13T12:48:31Z Re: Disappearing Conditional Expressions in straight table... https://community.qlik.com/t5/QlikView/Disappearing-Conditional-Expressions-in-straight-table/m-p/1254605#M517834 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Index(GetFieldSelections(REPORT_CRITERIA_E_DESC<SPAN style="color: #ff0000;">, ',', 1000000</SPAN>),'Regulation Exceptions')&gt;0</STRONG></P></BODY></HTML> Tue, 13 Dec 2016 16:29:15 GMT https://community.qlik.com/t5/QlikView/Disappearing-Conditional-Expressions-in-straight-table/m-p/1254605#M517834 sunny_talwar 2016-12-13T16:29:15Z Re: Disappearing Conditional Expressions in straight table... https://community.qlik.com/t5/QlikView/Disappearing-Conditional-Expressions-in-straight-table/m-p/1254606#M517835 <HTML><HEAD></HEAD><BODY><P>Read about the parameters within GetFieldSelections here: <A href="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/FieldFunctions/getfieldselections.htm" title="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/FieldFunctions/getfieldselections.htm">GetFieldSelections ‒ QlikView</A></P></BODY></HTML> Tue, 13 Dec 2016 16:30:11 GMT https://community.qlik.com/t5/QlikView/Disappearing-Conditional-Expressions-in-straight-table/m-p/1254606#M517835 sunny_talwar 2016-12-13T16:30:11Z Re: Disappearing Conditional Expressions in straight table... https://community.qlik.com/t5/QlikView/Disappearing-Conditional-Expressions-in-straight-table/m-p/1254607#M517836 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny T - this worked perfectly</P></BODY></HTML> Tue, 13 Dec 2016 16:51:43 GMT https://community.qlik.com/t5/QlikView/Disappearing-Conditional-Expressions-in-straight-table/m-p/1254607#M517836 siobhancrossen 2016-12-13T16:51:43Z