Suppress a chart with one of the categories displaying below a specified threshold

[pgaska]

Hi,

I have the following problem. I have a bar chart with a count of values over multiple categories. I need the chart not to display anything if any of the categories show counts below 10. How to achieve this? Is it even possible? I know how to hide if a total count is less than 10 but that's not the behaviour I want.

So for instance:

Category A - 5, Category B - 11, Category C 25 - then don't display

Category A - 11 Category B - 15, Category C 31 - display

Many thanks,

Pawel

[Oleg_Troyansky · Accepted solution]

Hi Pawel,

You can use the "Calculation Condition setting" - it's in the chart settings, under "Add-Ons".

The condition could be something like this:

min(AGGR(count(Category), Category)) > 10  

The default message in this case would be "Calculation condition unfulfilled", but you could replace it with any message of your own.

To learn more advanced development techniques, check out the agenda of the Masters Summit for Qlik - coming soon to Orlando and to Dublin!

[pgaska]

Hey Oleg,

Thanks, with a couple of tweaks, that worked perfectly!

[pgaska]

Hey Oleg,

one more question, there is one odd behaviour I experience I didn't manage to find a solution for. When there are some null values in the category and these are below a threshold, the formula suppresses the chart (even when the include null values tick box is unchecked).

Any idea how to resolve this?

Many thanks,

Pawel