Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
anitamanders
Contributor II
Contributor II

count total disregarding selection

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.

customergrouppruductgroupsuppliercount customers:
A1a5
A1b5
A1c6
A2d7
A2e3
A2f13
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

5 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

you could use

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

anitamanders
Contributor II
Contributor II
Author

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

it should be 39

salto
Specialist II
Specialist II

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.

anitamanders
Contributor II
Contributor II
Author

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.

salto
Specialist II
Specialist II

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...