minimum column width for traffic light gauge in straight table

[#1]

HI

I am trying to show a red/green dot in a straight table for marking good/bad values.

Tried for a long time and discovered finally that

a) the gauge is only displaying when the property dialog is closed, Apply is of no use for this.

b) the dot starts to shrink when the column with is less than 3 cm on my screen, with smaller column width it simply disappears

Could not find any setting that changes that behaviour. Need a column width that will just show a the dot without the empty space to the right of the gauge. Maybe use different dot-images instead of the gauge?

Juerg

[Clever_Anjos]

My gauge shows like this.

Is it what you want?

[agilos_mla]

Make it simple... Why don't you use simply the background color of the column? Just create a column with expression = '', but add an expression in the background properties.

[#4]

Hi Michael

Thanks but a dot is requested and coloring the cell will give me a rectangle

Mit freundlichem Gruss

Jürg Maier

Wincasa AG

+41 52 268 87 68

Von: Michaël Laenen

Gesendet: Montag, 3. Februar 2014 20:57

An: Maier Jürg

Betreff: Re: - minimum column width for traffic light gauge in straight table

Qlik Community<http://community.qlik.com/>

minimum column width for traffic light gauge in straight table

reply from Michaël Laenen<http://community.qlik.com/people/AGILOS.MLA?et=watches.email.thread> in App Development - View the full discussion<http://community.qlik.com/message/461196?et=watches.email.thread#461196>

[#5]

Hi Clever

Thanks, that looks close, would prefer plain color but it looks good. What’s the trick?

Mit freundlichem Gruss

Jürg Maier

Wincasa AG

+41 52 268 87 68

Von: Clever Anjos

Gesendet: Montag, 3. Februar 2014 20:40

An: Maier Jürg

Betreff: Re: - minimum column width for traffic light gauge in straight table

Qlik Community<http://community.qlik.com/>

minimum column width for traffic light gauge in straight table

reply from Clever Anjos<http://community.qlik.com/people/cleveranjos?et=watches.email.thread> in App Development - View the full discussion<http://community.qlik.com/message/461194?et=watches.email.thread#461194>

[agilos_mla]

If you want light bubbles are the settings : Choose trafic light gauge in Display option,

Then adjust the gauge settings to your case (Cfr screenhshots).

Anyway, let's always challenge your end users about vizualisatio. I'm not fond of gauge and traffic lights, does Tableau has gauge or lights ? No. 😉

if you nee 3 colors, create three segments. Use single light mode for the indicator.

[#7]

Hi Michael

Must be something strange with my straight table. If I just create a fresh example it works as expected (only that “Apply” in the properties clears the gauges out for some reason and they only show again once the properties dialog is closed)

Thanks for your help

Mit freundlichem Gruss

Jürg Maier

Wincasa AG

+41 52 268 87 68

Von: Michaël Laenen

Gesendet: Dienstag, 4. Februar 2014 08:24

An: Maier Jürg

Betreff: Re: - minimum column width for traffic light gauge in straight table

Qlik Community<http://community.qlik.com/>

minimum column width for traffic light gauge in straight table

reply from Michaël Laenen<http://community.qlik.com/people/AGILOS.MLA?et=watches.email.thread> in App Development - View the full discussion<http://community.qlik.com/message/461371?et=watches.email.thread#461371>

[agilos_mla · Accepted solution]

It is the normal behaviour, I don'y no why. Most probably due to some limitations of the chart engine.

Michael

[Clever_Anjos]

PFA