topic Adding Data Bar to Straight Table in QlikView

Adding Data Bar to Straight Table

Mon, 19 Mar 2012 14:07:50 GMT

In an Excel Pivot Table I have added conditional formatting "Data Bar" to the data to make it look like the following:

Is there a way to add this type of data graph to straight table cells?

Adding Data Bar to Straight Table

Anonymous — Mon, 19 Mar 2012 14:15:43 GMT

- Create a table via the Chart functions option (not a normal table but a chart table)

- Create a expression to obtain the data as required.

- Then on the Expressions Tab.....

- Display Options - select Linear Guage

Then you will see a guage settings option button. YOu should be able to test with the various settings to get what you want here.

Adding Data Bar to Straight Table

Mon, 19 Mar 2012 14:28:26 GMT

hamishimrie,

This was something new that I learned but I need it to make a gauge based on the other values in the column cells. The values in the column are based on an expression sum(YTDPremium). I only see in the gauge settings that I can set the segment limits.