topic Re: Use of count function in set analysis in QlikView

Use of count function in set analysis

Wed, 13 Feb 2013 05:25:13 GMT

Hi i have a simple table with productid , customerid , amount

ProductID	customerID	Amount
p01	h01	100
p02	h02	130
p03	h01	100
p04	h03	150

is want a simple chart which gives me the list of customers who has purchased more than 2 products so for that i am using

this expression

if(count(DISTINCT ProductID)>1,count(distinct ProductID))

and customID as my dimension .

Is there any way that i can use Set analysis for count(productID) >1 in the expression itself as the above method takes to long to process the data .?

Thanks and regards

s_tushar

Re: Use of count function in set analysis

SunilChauhan — Wed, 13 Feb 2013 05:28:14 GMT

not sure but this might work

Count({<count(DISTINCT ProductID)={">1"}>} distinct ProductID)

Re: Use of count function in set analysis

jvishnuram — Wed, 13 Feb 2013 05:40:41 GMT

Hi s_tushar,

Find the attachment,Hope it helps you

Re: Use of count function in set analysis

Wed, 13 Feb 2013 05:55:10 GMT

The output should contain the list of customers who have bought more than 1 product in this case the customerID should be h01 as he has bought product p01 and p03

Re: Use of count function in set analysis

er_mohit — Wed, 13 Feb 2013 05:55:34 GMT

hiii

use this

if(count( ProductID)>1,Count( ProductID))

Re: Use of count function in set analysis

Wed, 13 Feb 2013 06:06:41 GMT

i have used this expression but the problem is its too resource intensive is there a way that i can use count function in set analysis it self like

count({<productID={"=count(productID)>1"}>}productID) but this doesnt work

as we use MAX , MIN functions inside set analysis is there a way that we can construct a query with count() function ?

Re: Use of count function in set analysis

sujeetsingh — Wed, 13 Feb 2013 06:12:59 GMT

Hi you can use a CUSTOMERID as Dimention And use Expression ="Count({$<ProductIDCounter={">1"}>}DISTINCT ProductID)"

Re: Use of count function in set analysis

Sun, 20 Dec 2015 21:54:14 GMT

Hi,

Maybe this could work :

=count({<CustomerID={"=count(distinct ProductID)>1"}>}Distinct ProductID)

Regards

Gilles