topic Re: Conditional layout based on current selections- not working in QlikView

Conditional layout based on current selections- not working

Mon, 04 Apr 2016 09:47:52 GMT

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?

Re: Conditional layout based on current selections- not working

kaushiknsolanki — Mon, 04 Apr 2016 12:37:50 GMT

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

Re: Conditional layout based on current selections- not working

sunny_talwar — Mon, 04 Apr 2016 13:13:39 GMT

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

Re: Conditional layout based on current selections- not working

Mon, 04 Apr 2016 13:48:43 GMT

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.

Re: Conditional layout based on current selections- not working

sunny_talwar — Mon, 04 Apr 2016 13:54:47 GMT

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