topic Re: How to write this set analysis in QlikView

How to write this set analysis

Thu, 28 Feb 2013 02:33:07 GMT

Hi All,

I have the following records

OrderId, IsCommunityMember,IsSeller

1, 0,1

2,0,1

3,1,1

Now the question is I want to count the orders, the condition is If only the order's Is communityMember =1 or IsSeller=1.

I mean even both 2 columns are =1, that order just can be only counted 1 times.

How to achieve it?

Thu, 28 Feb 2013 03:09:58 GMT

Count({$<IsCommunityMember={1}>+<IsSeller={1}>} Distinct [OrderID])

Thu, 28 Feb 2013 03:48:35 GMT

Hi Donald,

Thanks for your quick reply, as you suggested, it shows the right result.

However, one more related question, there you used distinct to remove the duplicated orders like Order 3, because Both 2 columns are 1.

But If I remove the distinct from you set analysis, it result also is 2 not 3.

I attached the QVW, could you help me again?

Thu, 28 Feb 2013 11:44:37 GMT

If you want only where IsCommunityMember = 1, or IsSeller = 1, but not where both = 1, then use:

Count({$<IsCommunityMember={1}>/<IsSeller={1}>} Distinct [OrderID])

Sat, 02 Mar 2013 03:36:43 GMT

Hi Donald,

What I wanted is, the "1" at least raises in the Column IsCommunity or IsSeller at least 1 times, then take into account.

OrderId, IsCommunityMember,IsSeller

1, 0,1

2,0,1

3,1,1

4,0,0

So for the above samle, we need to remove Order4, because there is no 1 in that 2 columns.

How to achieve that?

Sat, 02 Mar 2013 13:38:40 GMT

I think that's where we started.

See attached. I've included a sample of each of the set operators for you to compare.