Count products

[spividori]

Hi.

In my example, I need to know the products that are available to compare with products sold in a period.

When I select a period, I also need to count the products that did not have sales.

Example.

I have a 2 products in Central and 3 products in Sucursal, and when I select "Sep", I need to continue counting the number of products in deposit.

See attachment.

Regards.

[kaushiknsolanki]

Hi,

     Could you tell me what output you are expecting from the given data set.

Regards,

Kaushik Solanki

[spividori]

Hi.

when I select "Sep", I need the set output showing the same value.

Regards.

[spividori]

Hi.

Any suggestions?, Please!.

Regards.

[MayilVahanan]

Hi

Due to need to exclude the month selection?

if so,

count({$<Mes=, Exi=-{0} >} NombreProdu)

hope it helps

[spividori]

Hi.

Thanks for responding.

In this case, yes, but I need it in a larger project where there may be several dimensions to exclude.

Regards.

[MayilVahanan]

Hi

Please refer this

http://community.qlik.com/docs/DOC-1334

For all dimension exclude,

use like this

=Sum({1}Sales)

Hope it helps