topic Re: List box expression null remove in QlikView

List box expression null remove

kstroupe — Tue, 10 Jan 2017 23:01:51 GMT

Hello all,

I have created a list box with an Employee field. I created an expression which works. It shows the Employee and the count of Assets they have.

=If(Count(DISTINCT {<status = {'Active'}>}Asset_ID)>1,Count(DISTINCT {<status = {'Active'}>}Asset_ID))

My issue is the counts that aren't greater then 1 have a dash next to the Employee field. I don't want those to show up on the list.

Do you know how I can remove them? I only want to see Employee 1 below

Employee	Asset	status
1	215369	Active
1	36985	Active
2	36895	Active

I see in list box

1 2

2 -

Thank you for your assistance.

Kim

Re: List box expression null remove

ger_alegria — Tue, 10 Jan 2017 23:19:26 GMT

Try with:

=If(Count(DISTINCT {<status = {'Active'}>}Asset_ID)=>1,Count(DISTINCT {<status = {'Active'}>}Asset_ID))

When you are evaluating you only take when the count is > 1, so if is only one value you count anything.

Re: List box expression null remove

kstroupe — Wed, 11 Jan 2017 01:14:29 GMT

Thank you for your Quick response. I put that in and it turns all the expression values to dashes. Here is what I was getting. Then I put a picture of the change.

Thanks

Re: List box expression null remove

parimikittu — Wed, 11 Jan 2017 06:38:39 GMT

Hi, If you want to have only the emplpoyees which has more than 1 Asset_ID? You also need to have the similar expression for Employee as well. create a list box with expression below:

aggr(if(Count(DISTINCT {<status = {'Active'}>}Asset_ID)>1,Employee ),Employee)

and then in expression tab give ur count logic "Count(DISTINCT {<status = {'Active'}>}Asset_ID)"

check this doc

How to show List box values conditional?

Re: List box expression null remove

kstroupe — Wed, 11 Jan 2017 14:58:11 GMT

Thank you this worked perfectly. I'm sorry I wasn't able to find the example you gave me. I'll mark it for future reference. Have a great day.