topic Re: one id linked to multiple status in QlikView

one id linked to multiple status

Fri, 19 Jul 2013 05:04:19 GMT

Hi,

I have an ID field which is linked to multiple part type.

For eg : id 10607 is linked to part type like zsp1,zret,zlab etc

id 10608 is linked to part type like zret,zlab etc

id 10609 is linked to part type like zret

Now i want to take the count of part type where zsp1 is not there.

It is counting 3 for id 10607 & not as 1 for zsp1.

i have tried this formula

=count(distinct if(part_type<>'zsp1',id))

=count(distinct if(part_type='zret' or part_type='zlab',id))

But i get all the calls where it has zsp1 also there after specifying te above condition.

Is it possible to take individulal line count ????

Can someone help me on this issue????

Re: one id linked to multiple status

suniljain — Fri, 19 Jul 2013 05:15:02 GMT

You can use following set analysis expression.

Count(Distinct {<Part_Type -={"zsp1"}>}id)

Re: one id linked to multiple status

Fri, 19 Jul 2013 05:21:03 GMT

hi sunil,

thanks for ur response, but this not working ,

as it has to take any id having zsp1 ,zret,zlab,zshm should not consider zsp1 for calculation & should give individual count as zret=1

zlab=1

zshm=4

& should not come 4 as overall.

Re: one id linked to multiple status

Fri, 19 Jul 2013 05:34:40 GMT

I think your code is write

=count(distinct if(part_type<>'zsp1',id))

if not work then you can try in script--

in script

write code-

load

id,

part_type

from table

where part_type<>'zsp1';

then in chart-

count(Distinct id)

Re: one id linked to multiple status

Sokkorn — Fri, 19 Jul 2013 06:17:18 GMT

Hi,

Did you try this yet

Count({$<Part_Type -={'zsp1'}>} Distinct id)

Regards,

Sokkorn

Re: one id linked to multiple status

Fri, 19 Jul 2013 09:47:28 GMT

Hi,

Thank you for the response,it is not working fine

i can give an example of the actual problem below:

part_type	id
ZRET	108826
ZLAB	108826
zsp1	108826
ZRET	108827
ZLAB	108827
zsp1	108827
zsp1	108828
zlab	108828
zret	108829
zlab	108829