topic Re: Selecting from Multiple Combination in QlikView

Selecting from Multiple Combination

Thu, 30 May 2013 21:54:30 GMT

Hello I have the following Table

USER_ID,

ONLINE_BOOKING_COUNT,

PHONE_BOOKING_COUNT

Here is a sample.

USER_ID	ONLINE_BOOKING_COUNT	PHONE_BOOKING_COUNT
469	3	3
325	0	1
974	1	3
322	2	0
503	2	4
734	0	0
283	1	5
280	1	0
283	0	5
900	0	0
974	3	1

I want to Count the Number of Users who Did the booking.

How do I count?

Thanks

Re: Selecting from Multiple Combination

Miguel_Angel_Baeyens — Thu, 30 May 2013 21:58:24 GMT

Hi,

You can use expressions in set analysis:

Count({< ONLINE_BOOKING_COUNT -= {0} > + < PHONE_BOOKING_COUNT -= {0} >} USER_ID)

That will return the set of USER_ID that are not zero in either ONLINE or PHONE. You can change that "+" for a "*" in case you want the intersection instead of the sum of sets (not zero in ONLINE AND in PHONE).

Hope that helps,

Miguel

Re: Selecting from Multiple Combination

Thu, 30 May 2013 22:23:16 GMT

Hi Miguel

Thank you for the quick response. I am trying to understand the set statement (for beginers like me I think need more practice). Is the above statement prevents duplicates as there are users who used bother ONLINE and OFFLINE. So we should count as one instead of two.

Also you mentioned the change '+' to '*' . what is intersection?

Re: Selecting from Multiple Combination

Miguel_Angel_Baeyens — Thu, 30 May 2013 22:27:39 GMT

Hi,

The "*" set modifier is used like the AND modifier, meaning "all in both set modifiers". In the case above, count when value is not zero for both fields.

Hope that helps,

Miguel