Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am having two filters in my report for Name and Date.
First I select a Name, then the date filter is enabled; then I select the Date. Then a pie chart showing some count of tasks is enabled (for the selected Name and Date).
I want the pie chart to be invisible when the count of tasks is NULL.
I wrote an expression such as : aggr(count(task), {$<[Name], [Date]>} [Name], [Date]) -= ''
But, this does not work. How can this be done?
Hi Kaushik/ Sunny,
I figured the problem. I had written it in the layout tab's conditional box itself but, my data contains null values which avoided QV from giving a proper count result. Hence I counted the tasks excluding the nulls from it, of-course with the help of Set Analysis
Thanks for your responses though.
Hi,
You can write this expression in Layout Tab of the chart properties under Show.
Select conditional and put below expression.
If(Your chart expression = 0,0,1)
Regards,
Kaushik Solanki
If Kaushik's solution doesn't work, would you be able to share a sample?
Hi Kaushik/ Sunny,
I figured the problem. I had written it in the layout tab's conditional box itself but, my data contains null values which avoided QV from giving a proper count result. Hence I counted the tasks excluding the nulls from it, of-course with the help of Set Analysis
Thanks for your responses though.
Great, Please close this thread by marking your answer as correct