topic Can we hide certain rows in a straight table based on an expression value? in QlikView https://community.qlik.com/t5/QlikView/Can-we-hide-certain-rows-in-a-straight-table-based-on-an/m-p/60264#M9966 <HTML><HEAD></HEAD><BODY><P>Hello, community.</P><P></P><P>I have a straight table chart with many dimensions, shown or conditionaly hidden, and some expressions...</P><P>One of those expressions is of the form:</P><P></P><P>if(col(1)=1 and col(2)=1,'Yes','No').</P><P></P><P>What i want is to give my users the ability to select all the 'No'&nbsp; or all the 'Yes' rows of the chart in order to focus their analysis only in one specific segment of the data or easily extract them in Excel...</P><P>Have in my mind that i cannot move the calculation (<SPAN style="font-size: 13.3333px;">if(col(1)=1 and col(2)=1,'Yes','No') ) in the LOAD script because the calculation must be dynamic according to the user input...</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Any ideas?</SPAN></P></BODY></HTML> Thu, 05 Apr 2018 09:19:09 GMT dapostolopoylos 2018-04-05T09:19:09Z Can we hide certain rows in a straight table based on an expression value? https://community.qlik.com/t5/QlikView/Can-we-hide-certain-rows-in-a-straight-table-based-on-an/m-p/60264#M9966 <HTML><HEAD></HEAD><BODY><P>Hello, community.</P><P></P><P>I have a straight table chart with many dimensions, shown or conditionaly hidden, and some expressions...</P><P>One of those expressions is of the form:</P><P></P><P>if(col(1)=1 and col(2)=1,'Yes','No').</P><P></P><P>What i want is to give my users the ability to select all the 'No'&nbsp; or all the 'Yes' rows of the chart in order to focus their analysis only in one specific segment of the data or easily extract them in Excel...</P><P>Have in my mind that i cannot move the calculation (<SPAN style="font-size: 13.3333px;">if(col(1)=1 and col(2)=1,'Yes','No') ) in the LOAD script because the calculation must be dynamic according to the user input...</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Any ideas?</SPAN></P></BODY></HTML> Thu, 05 Apr 2018 09:19:09 GMT https://community.qlik.com/t5/QlikView/Can-we-hide-certain-rows-in-a-straight-table-based-on-an/m-p/60264#M9966 dapostolopoylos 2018-04-05T09:19:09Z