topic Re: Set analyse problem in QlikView

Set analyse problem

Wed, 24 Apr 2013 09:42:37 GMT

HELLO!

I want to calculate the count (TYPE) with the set anayse definition as TYPE={SEL_TYPE_01,NULL}, where SEL_TYPE_01 is the name of a selection list, and NULL is a subset where TYPE is NULL.

The result is something like count{<TYPE={SEL_TYPE_01,NULL}>TYPE}

If you have any idea or advice,

THANKS for your response !!!!

Re: Set analyse problem

Wed, 24 Apr 2013 10:40:03 GMT

try this

aggr(count({<TYPE={''}>}TYPE),SEL_TYPE_01)

Re: Set analyse problem

er_mohit — Wed, 24 Apr 2013 10:47:34 GMT

try this

count(distinct {<TYPE={0}>}TYPE)

count(distinct {<TYPE={' '}>}TYPE)

if you can't get the output then try this

aggr(count(distinct {<TYPE={0}>}TYPE),SEL_TYPE_01)

aggr(count(distinct {<TYPE={' '}>}TYPE),SEL_TYPE_01)

Re: Set analyse problem

narender123 — Wed, 24 Apr 2013 10:47:51 GMT

I dont get your point,

I think you want his

count{<TYPE={'SEL_TYPE_01'}>TYPE}

Re: Set analyse problem

Wed, 24 Apr 2013 11:26:47 GMT

Something like this:

=count ({SEL_TYPE_01} TYPE)+NullCount(TYPE)

Re: Set analyse problem

sujeetsingh — Wed, 24 Apr 2013 11:43:26 GMT

Just go for:

COUNT({<TYPE={SEL_TYPE_01},{TYPE=NULL}>TYPE)