topic Re: count total disregarding selection in QlikView

count total disregarding selection

anitamanders — Mon, 14 Oct 2013 13:24:04 GMT

Hi you all,

i have the following:

productgroups (1,2,3,4 etc)

customers are divided into customergroups (A,B,C,D etc)

per customer and productgroup i have the supplier.

customergroup	pruductgroup	supplier	count customers:
A	1	a	5
A	1	b	5
A	1	c	6
A	2	d	7
A	2	e	3
A	2	f	13
TOTAL:			39

To calculate the marketshares of the different suppliers i want to:

Count

(TOTAL<productgroup> [customer])/Count(TOTAL<customergroup> [customer])

but this doesn't work. Because when i select only productgroup 1, the count of total customergroup gives 16 (5+5+6) instead of 39

who can help me out

Re: count total disregarding selection

bbi_mba_76 — Mon, 14 Oct 2013 13:36:19 GMT

Hi,

you could use

count({<productgroup=>} [customer])/Count({<productgroup=>} TOTAL<customergroup> [customer])

Re: count total disregarding selection

anitamanders — Mon, 14 Oct 2013 13:45:52 GMT

no, total customer still is 16 when i select productgroup 1

it should be 39

Re: count total disregarding selection

salto — Mon, 14 Oct 2013 14:03:00 GMT

Hi,

to disregard a selection you should use the '1' modifier ni the set analysis. Maybe trying something like :

= count({1<[customers]>} customers)

You would get 39 (the total number of customers disregarding the selections made)

Hope this helps.

Re: count total disregarding selection

anitamanders — Tue, 15 Oct 2013 08:36:01 GMT

hi,

sorry maybe I was not clear.

I also have a customergroup B, C etc. with productgroups 1,2,3.

In total over 400 customers.

I already tried wath Salto sugested, but than I get all 400 customers. What i need is when I select customergroup A 39 customers, when i select customergroup B 100 customers etc. etc. disregarding all other selections i make in productgroup etc.

Re: count total disregarding selection

salto — Tue, 15 Oct 2013 10:07:13 GMT

Hi,

Count ( { $ <supplier =, productgroup = > } customer)

will disregard the selections in fields "supplier" and "productgroup", and count the customers in the rest of selections made.

Hope this is of help to you...