Re: one id linked to multiple status - Qlik Community

Report Inappropriate Content · ‎2013-07-19

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????

suniljain · ‎2013-07-19

You can use following set analysis expression.

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

Report Inappropriate Content · ‎2013-07-19

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.

Report Inappropriate Content · ‎2013-07-19

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)

Sokkorn · ‎2013-07-19

Hi,

Did you try this yet

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

Regards,

Sokkorn

Report Inappropriate Content · ‎2013-07-19

Hi,

Thank you for the response,it is not working fine

i can give an example of the actual problem below: