topic Re: ListBox Expression in QlikView

ListBox Expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have an expression =Count(DAYS_PENDING) for a stragiht table with dimensions Division, Region and PendingBucket.

I would like to create a list box that represents the straight table above, into two categories. Assigned vs UnAssigned. If count is greater then 1 Unassigned, else Assigned.

Re: ListBox Expression

miguelbraga — Wed, 07 Sep 2016 14:51:41 GMT

Hey there,

Do you have a sample qvw that you can share, so that we can make you a solution for your issue?

Regards,

Re: ListBox Expression

Anil_Babu_Samineni — Wed, 07 Sep 2016 14:54:45 GMT

Try This

If(Count(DAYS_PENDING) > 1,'Unassigned', 'assigned')

If(Len(Count(DAYS_PENDING)) > 1,'Unassigned', 'assigned')

Re: ListBox Expression

effinty2112 — Wed, 07 Sep 2016 15:11:00 GMT

Hi John,

As a first attempt create a listbox with this expression:

=Aggr(If(count(DAYS_PENDING) >1,'Assigned','Unassigned'), FieldName)

The thing to figure out here is the Fieldname to choose, try it on the dimension with the finest granularity.

I think there might be a bit of work to be done on the logic behind your requirements before we can get a solution.

Good luck

Andrew

Re: ListBox Expression

sunny_talwar — Wed, 07 Sep 2016 15:14:09 GMT

This would create the two buckets for you, but will not work well based on selections

Aggr(If(Count(DAYS_PENDING) > 1, 'Unassigned', 'Assigned'), Division, Region and PendingBucket)

Can you do the count in the script to create the flag for unassigned and assigned?

Re: ListBox Expression

Anonymous — Wed, 07 Sep 2016 18:11:55 GMT

I was able to create a Case Statement in my Script to solve the problem.

CASE

WHEN A.FIRST_ASSGN_DT IS NOT NULL

THEN 'Assigned'

WHEN A.FIRST_CONTACT_DT IS NOT NULL THEN 'Assigned'

WHEN A.FIRST_VISIT_DT IS NOT NULL THEN 'Assigned'

ELSE 'UnAssigned'

END Assigned