topic Re: Count products in QlikView

Count products

spividori — Fri, 22 Mar 2013 10:08:42 GMT

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 — Fri, 22 Mar 2013 10:26:22 GMT

Hi,

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

Regards,

Kaushik Solanki

spividori — Fri, 22 Mar 2013 12:03:38 GMT

Hi.

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

Regards.

spividori — Fri, 22 Mar 2013 20:02:09 GMT

Hi.

Any suggestions?, Please!.

Regards.

MayilVahanan — Fri, 22 Mar 2013 20:15:57 GMT

Due to need to exclude the month selection?

if so,

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

hope it helps

spividori — Fri, 22 Mar 2013 20:26:34 GMT

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 — Fri, 22 Mar 2013 20:32:39 GMT

Please refer this

For all dimension exclude,

use like this

=Sum({1}Sales)

Hope it helps