topic Conditional Hide Expression based on Dimension Value in QlikView https://community.qlik.com/t5/QlikView/Conditional-Hide-Expression-based-on-Dimension-Value/m-p/966020#M331138 <HTML><HEAD></HEAD><BODY><P>I have not found a thread on this topic, so I'm hoping someone can help now.&nbsp; I have a pivot table with 2 expressions.&nbsp; I want Expression1 to show with all dimensions, but I want Expression2 to only show when dimension value = 'A' or 'B', not for 'C' or 'D'.</P><P></P><P>I know i can exclude the values with an if statement embedded in the expression, but then I have expression columns that are always blank and just taking up space... and the user is requesting they be suppressed for those dimension values.&nbsp; </P><P></P><P>I have tried using the Conditional Show feature on the expression with If(Match(Brand,'A','B'),1,0) but that hides the expression for every dimension.</P></BODY></HTML> Thu, 20 Aug 2015 21:10:39 GMT 2015-08-20T21:10:39Z Conditional Hide Expression based on Dimension Value https://community.qlik.com/t5/QlikView/Conditional-Hide-Expression-based-on-Dimension-Value/m-p/966020#M331138 <HTML><HEAD></HEAD><BODY><P>I have not found a thread on this topic, so I'm hoping someone can help now.&nbsp; I have a pivot table with 2 expressions.&nbsp; I want Expression1 to show with all dimensions, but I want Expression2 to only show when dimension value = 'A' or 'B', not for 'C' or 'D'.</P><P></P><P>I know i can exclude the values with an if statement embedded in the expression, but then I have expression columns that are always blank and just taking up space... and the user is requesting they be suppressed for those dimension values.&nbsp; </P><P></P><P>I have tried using the Conditional Show feature on the expression with If(Match(Brand,'A','B'),1,0) but that hides the expression for every dimension.</P></BODY></HTML> Thu, 20 Aug 2015 21:10:39 GMT https://community.qlik.com/t5/QlikView/Conditional-Hide-Expression-based-on-Dimension-Value/m-p/966020#M331138 2015-08-20T21:10:39Z Re: Conditional Hide Expression based on Dimension Value https://community.qlik.com/t5/QlikView/Conditional-Hide-Expression-based-on-Dimension-Value/m-p/966021#M331139 <HTML><HEAD></HEAD><BODY><P>Yes, the condition for the expression will be evaluated once per chart, not per dimension value.</P><P></P><P>And no, I believe you can't hide an expression column completely only for certain dimension values using QV table charts.</P></BODY></HTML> Thu, 20 Aug 2015 21:18:11 GMT https://community.qlik.com/t5/QlikView/Conditional-Hide-Expression-based-on-Dimension-Value/m-p/966021#M331139 swuehl 2015-08-20T21:18:11Z