Discussion Board for collaboration on QlikView Layout & Visualizations.
I am not getting the correct result when I want to display the result as a text in the chart though I am using the same expression which I used in the expression tab. Whereas in the other chart I am able to get the correct result by using the same expression which was used in the expression tab but why not the these two gauge chart(Revenue v Last Year and Margin v Last Year as shown in the screen shot) is not showing the expected result.
I am not able to find out where is he mistake! Hope some one can help me out.
You're using a dimension in the gauge "Revenue v Last Year", LimitYTD. In order for the dimensionless "Text in Chart" to return the same value you need to aggregate over the dimension value like this:
Take a look at aggr() in the reference manual and F1-help for clarification
Can you please find it out why there is a problem in the "AR - Day Sales O/S" Gauge chart. The result which I am showing in the chart and actual result seems to be mismatching though I use the expression that has been sent by you. Requesting you to look into it and provide some solution for me.
Screen shot for better understanding:
Both values are correct since you have values associated with null values in the dimension, LimitYTD.
Anyway, if you add an if-statement to the little text object to check for null values in the dimension you should get the same values as in the gauge itself: