topic Hide linear gauge mini chart from Total line in QlikView

Hide linear gauge mini chart from Total line

dafnis14 — Tue, 16 Jan 2018 06:50:20 GMT

Hi,

I'm using the linear gauge in a straight table.

After selecting No Totals, and using the Dimensionality() function, the gauge is still displayed in the total line.

if( Dimensionality()=1, avg(Income_Variance%),null())

Other gauge types work as expected.

Is there a known issue with this type of mini chart?

Thanks!

Message was edited by: Dafnis X Added a QVW

Re: Hide linear gauge mini chart from Total line

tresB — Tue, 16 Jan 2018 06:57:39 GMT

Could you post a sample qvw that demonstrates and help us understand the issue better?

Re: Hide linear gauge mini chart from Total line

dafnis14 — Tue, 16 Jan 2018 07:05:37 GMT

Just did.

Thanks!

Re: Hide linear gauge mini chart from Total line

tresB — Tue, 16 Jan 2018 07:19:02 GMT

It seems the issue is with only 'Show Needle' in the Indicator->Mode under guage settings. If you change the Mode to something else it works. I am not sure if it's by-design or know-issue. May be others can share their views here.

Re: Hide linear gauge mini chart from Total line

uacg0009 — Tue, 16 Jan 2018 07:23:14 GMT

Hi Dafnis,

So what's the result is you want? Just don't show the total column like this:

If yes, you just need to also select the No total for Dimensionality expression.

Thanks.

Aiolos

Re: Hide linear gauge mini chart from Total line

dafnis14 — Tue, 16 Jan 2018 07:31:38 GMT

Hi Aiolos,

I need the total for sales though. Even if you remove the Dimensionality() column, the issue still persists.

This happens only with the linear type of gauge.

Thanks..