topic Conditionally Show Gauge in Straight Table Based on Row in QlikView https://community.qlik.com/t5/QlikView/Conditionally-Show-Gauge-in-Straight-Table-Based-on-Row/m-p/160446#M34722 <HTML><HEAD></HEAD><BODY><P>Hi everyone, I've tried almost everything under the sun to hide one of my gauges that is showing up in my straight table (see picture below). I've even tried using a calculated background color based on if the current row, "Key Metrics" so that I could make it gray and it would be hidden essentially. This does not work. Am I missing something?</P><P>Here's my expression to calculate one of the segment colors, it seems to just always be false, Measure is the dimension in the table:</P><P>=if(Measure='Key Metrics',RGB(240,240,240),RGB(252,115,98))</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-2133_sourceID:2133" /></P><P>Don't worry the data is scrambled <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Fri, 13 Aug 2010 22:41:24 GMT 2010-08-13T22:41:24Z Conditionally Show Gauge in Straight Table Based on Row https://community.qlik.com/t5/QlikView/Conditionally-Show-Gauge-in-Straight-Table-Based-on-Row/m-p/160446#M34722 <HTML><HEAD></HEAD><BODY><P>Hi everyone, I've tried almost everything under the sun to hide one of my gauges that is showing up in my straight table (see picture below). I've even tried using a calculated background color based on if the current row, "Key Metrics" so that I could make it gray and it would be hidden essentially. This does not work. Am I missing something?</P><P>Here's my expression to calculate one of the segment colors, it seems to just always be false, Measure is the dimension in the table:</P><P>=if(Measure='Key Metrics',RGB(240,240,240),RGB(252,115,98))</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-2133_sourceID:2133" /></P><P>Don't worry the data is scrambled <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Fri, 13 Aug 2010 22:41:24 GMT https://community.qlik.com/t5/QlikView/Conditionally-Show-Gauge-in-Straight-Table-Based-on-Row/m-p/160446#M34722 2010-08-13T22:41:24Z