topic Re: Issue with linear guage rep in straight table in QlikView

Issue with linear guage rep in straight table

Fri, 20 Nov 2015 19:14:57 GMT

Hi,

I have a small issue/requirement with Linear Gauge in the straight table. I want to show the % along with the representation.

Can anyone help me with this?

A screenshot has been attached.

Thank you in advance.

Regards,

Sachin

Re: Issue with linear guage rep in straight table

maxgro — Fri, 20 Nov 2015 19:46:52 GMT

Hope to be wrong but I don't think it's possible in the same column.

You can add a column.

Re: Issue with linear guage rep in straight table

Fri, 20 Nov 2015 21:14:39 GMT

Hi,

Can I overlap table on top of table. If yes, can you let me know the rgb() value to make the background color for that expression transparent.

Regards,

Sachin

Re: Issue with linear guage rep in straight table

maxgro — Sat, 21 Nov 2015 08:42:50 GMT

green(0)

argb(0,0,255,0)

the bold parameter is opacity

ARGB(alpha, e1, e2, e3)

An alpha of 0 corresponds to full transparency. An alpha of 255 corresponds to full opacity.

Re: Issue with linear guage rep in straight table

Sat, 21 Nov 2015 13:08:27 GMT

Thank you.

So as per my understanding I need to overlap chart with actual values on top of chart with linear gauge and then make the background for the required expression as white(0).

Re: Issue with linear guage rep in straight table

swuehl — Sat, 21 Nov 2015 14:31:19 GMT

I would not mess around with overlay charts if not absolutely necessary. In your case, just adding another column like maxgro suggested should give you similar results, but much better maintainable.

A single chart could look like

Re: Issue with linear guage rep in straight table

veidlburkhard — Sat, 21 Nov 2015 14:51:25 GMT

Hi Aditya,

there is an easy workaround to achieve your favoured result in one straight table. Look this example:

You have to place the numerical column just behind your linear gauge column. Set the header of the numerical column to =' ' , got to the Presentation Tab and mark the alignment of Data(numeric) to Left. Then go to Chart Properties, Style and uncheck the 'Vertical Expression Cell Borders'. After that you got a result similar to the above.

Happy qliking

Burkhard

Re: Issue with linear guage rep in straight table

nagarjuna_kotha — Sat, 21 Nov 2015 15:00:08 GMT

Hi swuehl ,

How did u do that?

Can you tell, How to achieve this? If you share sample file that would be more helpful to me.

Regards,

Nagarjuna

Re: Issue with linear guage rep in straight table

swuehl — Sat, 21 Nov 2015 15:05:52 GMT

Attached the sample from my previous post (which has been also explained well by the following poster).