topic Re: aggr with set analysis in QlikView

aggr with set analysis

Wed, 13 Nov 2013 10:13:21 GMT

How i can write aggr funcation with set analysis.

My expression is-- count(aggr(if(count(index_id)>1,ID,emp_name,Sup_Name)))

Please help me urget basic.

Thanks in advance

Regards

Ashish

Re: aggr with set analysis

sibin_jacob — Wed, 13 Nov 2013 10:17:58 GMT

Hi Ashish,

Can you please elaborate your requirement.

Thanks,

Sibin Jacob.C

Re: aggr with set analysis

tresB — Wed, 13 Nov 2013 10:20:46 GMT

Are you sure this is the right expression you are using? I guess there is some parenthesis issue.

Re: aggr with set analysis

Wed, 13 Nov 2013 10:28:47 GMT

I want count(distinct id) where count(distinct index_id)>1

Regards

Ashish

Re: aggr with set analysis

jagan — Wed, 13 Nov 2013 10:31:41 GMT

Hi,

You missed on parenthesis

=count(aggr(if(count(index_id)>1,ID,emp_name),Sup_Name)))

I don't understand what you are doing with this, you are getting the count of SupName, you can also get the same by using below expression. No need of Aggr().

=Count(DISTINCT Sup_Name)

Regards,

Jagan.

Re: aggr with set analysis

jagan — Wed, 13 Nov 2013 10:33:35 GMT

Hi,

Try this

Sum(Aggr(If(count(distinct index_id)>1, 1, 0), id))

Hope this helps you.

Regards,

Jagan.

Re: aggr with set analysis

tresB — Wed, 13 Nov 2013 10:37:08 GMT

May be like:

Count( {$<id = P({1<index_id={"=count(Distinct inex_id)>1"}>} id)>} Distinct id )

If not this, please share your sample app.