How to hide ' Total ' text and and respective of ' zero' value in Pie Chart Qliksense
Hi,
As per requirement, we enabled ' Total ' in appearance of Pie chart and kept it in middle of the pie chart.
Which is showing the values according to filter selections but we dont want to show the 'total' text and respective of 'zero' values according to filter selections.
Request you to kindly let me know the solution and help me out on this.
Its not clear what you are asking. Do you want to override the selections for the total? If so, use this syntax in the expression/measure:
Sum({1}TOTAL YourField)
Amend this to your requirements and field names. The {1} means ignore all selections and can be used in any aggregation function (Sum/Max/Avg/Count/Concat etc).
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
I sincerely thank you for your quick response ans I am sorry for not given details explanation.
I am looking for that how can i hide ' Total ' text and ' 0.00 ' value in pie chart... basically i want to hide these when the total value is zero...if you can observe the chart is not visible..same like we need to hide ' total ' text and zero value (0.00) as well from Pie chart which is in center of the chart.
Please find attached screenshot for your reference.
