topic Re: Set anlysis in QlikView

Set anlysis

jyothish8807 — Thu, 17 Oct 2013 11:42:27 GMT

Hi,

I have following data:

Now i want Count of Type for all users where count is >2.

Regards

Jyothish KC

saumyashah90 — Thu, 17 Oct 2013 11:45:40 GMT

count(<{Count(Type)>={'2'}}> Type)

christian77 — Thu, 17 Oct 2013 11:50:25 GMT

Your post is not very clear to me.

count( {$< Type={'>2'}>} distinct Name)

count( {$< Name={'=count(Name)>2'}>} distinct Name)

Users = Name?

Count = Count Name appearings?

Count = Count Type appearings?

CELAMBARASAN — Thu, 17 Oct 2013 11:57:21 GMT

Try this

Count({<Name={"=Count(Distinct Type)>2"}>} Distinct Type)

MayilVahanan — Thu, 17 Oct 2013 12:06:33 GMT

PFA

rustyfishbones — Thu, 17 Oct 2013 12:47:14 GMT

You can try this

Thu, 17 Oct 2013 13:10:21 GMT

PFA

sudeepkm — Thu, 17 Oct 2013 13:35:35 GMT

have you checked using aggr() like below. You can use the below expr in a list box which will show you the names where count is >2.

=if(aggr(count(Type),Name)>2,Name)

jyothish8807 — Fri, 18 Oct 2013 04:17:57 GMT

Hi,

My requirement if little more specific. My output columns should be like this:

Name	1	2	3
a		2

There should be two condition:

Type should be '1' and count >=2. for second column.

Type should be '2' and count>=2. for third column.. and so on.

Regards

Jyothish KC