topic Customizing Gauge on the Pivot Table in QlikView

Customizing Gauge on the Pivot Table

triekong — Wed, 13 Dec 2017 21:02:51 GMT

i have a pivot table. i have set one of the columns to "linear gauge".

i am having trouble customizing the gauge bars in the column, i would like it to be thinner (not fill up the entire cell). i have tried editing the gauge settings in the 'expressions' tab, but none of the settings are accommodating this.

i also tried changing the multiline settings in the 'presentation' tab; the problem with this is, it changes the sizes of all the cells in all the columns, instead of just the cell containing the bar.

is it possible at all? or anyone know a workaround?

i have attached the QV document here.

Thanks!

Re: Customizing Gauge on the Pivot Table

krishnacbe — Wed, 13 Dec 2017 21:31:23 GMT

Hope you have set the Wrap option to 4, if you uncheck the option the bar height got reduced automatically.

Re: Customizing Gauge on the Pivot Table

triekong — Wed, 13 Dec 2017 21:43:40 GMT

thanks for your response!

but the problem is, it reduces the height of the row cells as well. i only want to reduce the height of the linear gauge to make it thinner.

i like the cell height as is, just don't want the gauge to fill up the entire cell space