# New to QlikView

Discussion board where members can get started with QlikView.

MVP

## Re: Count Zeros by Set Analysis or If Statement

I think I don't understand what you are talking about.

Could you upload a small sample QVW?

Esteemed Contributor II

## Re: Count Zeros by Set Analysis or If Statement

Try as below

count({<company = {"=Sum(Sale)=0"}>}company)

Contributor II

## Re: Count Zeros by Set Analysis or If Statement

Hi Sunny,

Please see the attached sample, there is a sum of last 12 months with a Cyclic Group, I tried all the statements as you guys suggested above.

I am looking to count only zeros and want to ignore null values.

Kind regards,

Farrukh

Contributor II

## Re: Count Zeros by Set Analysis or If Statement

Hi Stefan,

I attached the sample data at Sunny's reply.

Can you please have a look.

Farrukh

MVP

## Re: Count Zeros by Set Analysis or If Statement

 Farrukh Shaikh wrote: Hi Stefan, I attached the sample data at Sunny's reply. Can you please have a look. Farrukh

Sorry, I can't see any attachment.

Contributor II

## Re: Count Zeros by Set Analysis or If Statement

here you go! sample data is attached!

Farrukh

Contributor II

## Re: Count Zeros by Set Analysis or If Statement

Hi Stefan,

I think its sorted. I used the below logic with set analysis, could you please advise me is it correct?

MVP

## Re: Count Zeros by Set Analysis or If Statement

Correct? Hard to tell without really knowing what you need to achieve.

If you want to count the records, I would probably write your expression like

Not sure if the YearMonth filter is correct, but if all your tests pass, then your expression is probably fine.

Highlighted
Contributor II

## Re: Count Zeros by Set Analysis or If Statement

Hi,

Is it that you want the sum of sales for the Month-Year & Region to be zero?

if so you can try this expression -