topic How to get the nums? in QlikView

How to get the nums?

Mon, 28 Mar 2011 07:40:51 GMT

Hi All,

I have the following table.

load * Inline
[
CountMemberId,Category
1,A
1,A
2,C
2,A
3,A

]

I want to use an expression to show how many members have bought at leaset 2 products whose category is A.

For this test, only one whose ID is 1.

How to finish it?

How to get the nums?

Miguel_Angel_Baeyens — Mon, 28 Mar 2011 07:53:13 GMT

Hello Isaac,

I'd use something like

Count({< CountMemberId = {"=Count({< Category = {'A'} >} CountMemberId) > 1"} >} DISTINCT CountMemberId)

Hope that helps.

How to get the nums?

Mon, 28 Mar 2011 08:03:38 GMT

Yes, it works, you are always my teacher.

Now I have an additional question on it.

If I want to get the nums who bought at least 2 product A or at least 1 product C, how to use set analysis, in this case, 1 have bought 2 A and 2 have bought 1 C, so the result is two, how to finish it?

Thanks Miguel Angel Baeyens.

How to get the nums?

Miguel_Angel_Baeyens — Mon, 28 Mar 2011 08:22:50 GMT

Hello,

Use

Count({< CountMemberId = {"=Count({< Category = {'A'} > + < Category = {'C'} >} CountMemberId) > 1"} >} DISTINCT CountMemberId)

That will return "1" for those CountMemberId who have bought either 2 "A" or 2 "C".

Hope that helps.