topic minimum column width for traffic light gauge in straight table in QlikView

minimum column width for traffic light gauge in straight table

Mon, 03 Feb 2014 19:35:01 GMT

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

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

Clever_Anjos — Mon, 03 Feb 2014 19:39:01 GMT

My gauge shows like this.

Is it what you want?

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

agilos_mla — Mon, 03 Feb 2014 19:56:20 GMT

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.

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

Tue, 04 Feb 2014 06:37:56 GMT

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>

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

Tue, 04 Feb 2014 06:40:20 GMT

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>

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

agilos_mla — Tue, 04 Feb 2014 07:22:46 GMT

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.

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

Tue, 04 Feb 2014 08:57:52 GMT

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

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

agilos_mla — Tue, 04 Feb 2014 09:06:34 GMT

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

Michael

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

Clever_Anjos — Tue, 04 Feb 2014 11:39:53 GMT

PFA