topic Re: Count Exclude if any in QlikView

Count Exclude if any

Mon, 13 Jul 2015 08:20:54 GMT

Hi guys,

Got confused in some calculation.

Doc No. Item Qty Customer

INV-01 A 2 ALPHA

INV-01 B 1 ALPHA

INV-02 B 2 DELTA

INV-03 A 1 OMEGA

i want to count how many customer that bought ITEM "B" only. so the correct answer should be "1"

can anybody help ?

MK_QSL — Mon, 13 Jul 2015 08:27:53 GMT

=SUM(Aggr(IF(Count({<Item = {'B'}>}DISTINCT Item)=1 and COUNT(DISTINCT Item)=1,1),Customer,[Doc No]))

Set Analysis

=COUNT({<[Doc No] = {"=Count({<Item = {'B'}>}Distinct Item)=1"}>*<[Doc No] = {"=Count(Distinct(Item))=1"}>}DISTINCT Customer)

alexandros17 — Mon, 13 Jul 2015 08:31:18 GMT

Try this expression in your chart:

Sum({$ <Item={'B'}>} If(Aggr(NODISTINCT Count(Item), Customer)=1,1,0))

let me know

antoniotiman — Mon, 13 Jul 2015 08:39:29 GMT

=Count({<Customer={"=Only(Item)='B'"}>} DISTINCT Customer)

Mon, 13 Jul 2015 09:04:11 GMT

Thanks Manish, i'm using your Set Analysis and it worked

Mon, 13 Jul 2015 09:04:45 GMT

Thanks Alessandro, but the result was wrong in my file.

Mon, 13 Jul 2015 09:05:50 GMT

Thanks Antonio , but didn;t show the correct answer.

Anonymous — Mon, 13 Jul 2015 09:53:18 GMT

=Count({<Item= {'B'}>}Customer)