Conditional layout based on current selections- not working

[#1]

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?

[kaushiknsolanki]

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

[sunny_talwar]

If Kaushik's solution doesn't work, would you be able to share a sample?

[#4 · Accepted solution]

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.

[sunny_talwar]

Great, Please close this thread by marking your answer as correct