Qlik Sense calculation condition in data handling

[user467341]

Hi.

I am trying to use "Calculation condition" in "Data Handling" for my pie chart. I used this formula:

=IF(COUNT(cat_id)>0,1,0)

When cat_id is more than 1, the pie chart still show

Is there a problem with my formula?

[PrashantSangle]

Remove else part and try

if(count(cat_id)>0,1)

[user467341]

Hi, seems like it is still the same.

[marcus_sommer · Accepted solution]

No if() is needed just: COUNT(cat_id) should work for the purpose. Before applying it in the condition check the results within a text-box. Maybe you queried the wrong field respectively misspelled the wanted one - Qlik is case-sensitive for all table/field/variable-names.