topic Re: Set Analysis in QlikView

Set Analysis

Wed, 24 Jul 2013 13:16:29 GMT

Hi,

Below is the requirement :[Data is vaialble in attachment]

1) Find count of members using P1 and P2 but not P3 by region

Dimension: Region

Expression: Count({ 10

Thanks

Ramesh

sivarajs — Wed, 24 Jul 2013 14:13:24 GMT

Dimension: if(Region<>P3,Region)

Exp:count( distinct members)

Dimension: Region

Exp:count({Region-={'P3'}}members)

Wed, 24 Jul 2013 15:18:49 GMT

Find count of members using P1 and P2 but not P3 by region
Dimension: Region
Expression: Count({<Member = p({<Product={P1}>}Member)*p({<Product={P2,P3}>}Member)>}Member)

Condition: A member might have bought products from different regions, but you have to consider a member for only one region based on max date of P2

Find the count of members for region who bought:
IF P1 – member visits >=2 and cumulative sum of quantity across a category greater than 90
IF P2 – member visits >=2 and quantity > 10

Sorry.. I missed in previous post

Thanks

Ramesh

Wed, 24 Jul 2013 15:25:47 GMT

1) I have to find members using P1 and P2 and not using P3 , which will help me to suggest P3 for members.

2) how to find sum of Quantity by Category per member by Region

thanks Sivaraj for your reply.