topic Straight Table Percent of Target in QlikView https://community.qlik.com/t5/QlikView/Straight-Table-Percent-of-Target/m-p/673937#M538532 <HTML><HEAD></HEAD><BODY><P>I have a straight table that shows my Dimension, YTD % and YTD Target. I know I've seen dashboards that visually displays the % relative to the target within a straight table, but I can't figure out how to do this. I can do it in a simple bar chart outside of a straight table and I know this is simple, so what easy solution am I not thinking of?</P><P></P><P>There are different targets based on the dimension.</P><P></P><P>Here is an example of what I am looking for:</P><P></P><P><IMG alt="chart.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/67453_chart.png" /></P><P>Thank you!</P></BODY></HTML> Tue, 23 Sep 2014 17:32:00 GMT cbaqir 2014-09-23T17:32:00Z Straight Table Percent of Target https://community.qlik.com/t5/QlikView/Straight-Table-Percent-of-Target/m-p/673937#M538532 <HTML><HEAD></HEAD><BODY><P>I have a straight table that shows my Dimension, YTD % and YTD Target. I know I've seen dashboards that visually displays the % relative to the target within a straight table, but I can't figure out how to do this. I can do it in a simple bar chart outside of a straight table and I know this is simple, so what easy solution am I not thinking of?</P><P></P><P>There are different targets based on the dimension.</P><P></P><P>Here is an example of what I am looking for:</P><P></P><P><IMG alt="chart.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/67453_chart.png" /></P><P>Thank you!</P></BODY></HTML> Tue, 23 Sep 2014 17:32:00 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Percent-of-Target/m-p/673937#M538532 cbaqir 2014-09-23T17:32:00Z Re: Straight Table Percent of Target https://community.qlik.com/t5/QlikView/Straight-Table-Percent-of-Target/m-p/673938#M538533 <HTML><HEAD></HEAD><BODY><P>Hi Cassandra,</P><P></P><P>I believe you're looking for a Linear Gauge within a straight table. Here is a thread with some examples: <A href="https://community.qlik.com/thread/40079">Straight Table chart with linear gauge chart</A></P><P></P><P>The example "Data Visualization" QVW that comes with QlikView, has an example of this minichart on the Sparklines sheet as well.</P></BODY></HTML> Wed, 24 Sep 2014 21:57:07 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Percent-of-Target/m-p/673938#M538533 joe_warbington 2014-09-24T21:57:07Z