topic Traffic Light Gauge Chart issue with if function in QlikView

Traffic Light Gauge Chart issue with if function

Wed, 13 May 2015 16:47:28 GMT

Good afternoon,

I have an issue with a Traffic light gauge chart.
I know how to set up gauge charts. My problem is, when on the Expression tab I use the Total Mode "Expression Total" the gauge works perfectly and according to the segment bounds I defined but the correct result and the one I want to use is the one from the Total Mode "Sum of lines" and the Gauge continues to work based on the "Expression Total" result.

Tried to go around this creating a count formula but got the same issue and the AGGR function doesn't help either.
Any ideas?

Thanks in advance

Sergio

Re: Traffic Light Gauge Chart issue with if function

Gysbert_Wassenaar — Thu, 14 May 2015 10:38:12 GMT

Can you post a qlikview document that demonstrates the problem?

Re: Traffic Light Gauge Chart issue with if function

Wed, 20 May 2015 17:00:03 GMT

Hi Gysbert,

Thank you for your reply and sorry for my late reply.

I built a simple report attached to replicate my issue.

The issue is actually a bit different than what I thought in the first place. The Gauge bounds are not working upon the formula total that I input (which is 200) but upon the first line result (40). Don't think there is anything wrong with the formula as it returns the result I want but don't manage to put the Gauge working on that total.

Any ideas to go around this?

Thank you

Re: Traffic Light Gauge Chart issue with if function

Gysbert_Wassenaar — Wed, 20 May 2015 17:46:33 GMT

The dimensions you added to the gauge chart don't do anything unless you enable the Trellis option. Otherwise the dimensions are ignored. See attached qvw.

Re: Traffic Light Gauge Chart issue with if function

Thu, 21 May 2015 09:04:41 GMT

Good Morning Gysbert,

Thank you for your support, I see what you mean about the trellis, you created one Chart per line result, although what I want is a chart for the total of the column "Difference" = 200 as per Total Mode: Sum of rows, how can I do that?

Thanks again

Sergio

Re: Traffic Light Gauge Chart issue with if function

Gysbert_Wassenaar — Thu, 21 May 2015 09:10:47 GMT

Remove all dimensions from the gauge chart and use this expression: =sum(aggr(fabs(sum(Balance1)-sum(Balance2)),Office))

Re: Traffic Light Gauge Chart issue with if function

Thu, 21 May 2015 09:29:15 GMT

Brilliant, thats what I was looking for

Tried to use the AGGR before but obviously didn't use it properly, I think I didnt remove the dimensions..

Thanks a lot!