topic Different behaviour between gauge chart and text object in QlikView

Different behaviour between gauge chart and text object

Mon, 20 Jul 2009 13:57:27 GMT

Hi,
We have a gauge chart and text object operating with the same formula. The text object always shows the correct information, whilst the gauge chart is erratic and doesn't always display the same value that is shown in the text object.
Has anyone come across this problem and have a solution to it?
TIA,
Lance

Different behaviour between gauge chart and text object

rwunderlich — Tue, 21 Jul 2009 06:04:31 GMT

Confirm that your gauge chart expression is an aggregation function, not just a field reference. Can you post the expression used in both objects?

-Rob

Different behaviour between gauge chart and text object

Tue, 21 Jul 2009 09:35:00 GMT

Rob, thanks for you response. This is the code for both fields:

sum(if(DEPTNO=4,[TOTAL SCRAP LENGTH],[TOTAL SCRAP UNITS]))/
sum(IF(DEPTNO=4,[TOTAL SCRAP LENGTH],[TOTAL SCRAP UNITS]))+sum(IF(DEPTNO=4,[TOTAL GOOD LENGTH],[TOTAL GOOD UNITS])))

Lance

Different behaviour between gauge chart and text object

rwunderlich — Wed, 22 Jul 2009 01:38:30 GMT

Nothing is jumping out at me. Can you post the qvw (or some data) as well?

-Rob

Different behaviour between gauge chart and text object

Anonymous — Wed, 22 Jul 2009 07:58:43 GMT

Lance,
I assume the answer is "no", just to make sure - are there any dimensions in the gauge chart?

Different behaviour between gauge chart and text object

Wed, 22 Jul 2009 12:27:28 GMT

Michael hi,
Thank you very much! Yes, there was a dimension in the gauge chart which caused this problem.
All the best,
Lance

Different behaviour between gauge chart and text object

Wed, 22 Jul 2009 12:29:04 GMT

Rob hi,
Thanks for your efforts to help out here. I had a dimension in the gauge chart which caused this problem.
Lance