topic Re: Expression in List Box in QlikView

Expression in List Box

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

I have the below expression but I am not seeing the correct results.

I have a column FIRST_ASSGN_DT. When this column is Null = UnAssigned. When this column is not null = Assigned.

=If(WildMatch(FIRST_ASSGN_DT, '*'),'Assigned')AND If(ISNULL(FIRST_ASSGN_DT),'UnAssigned')

trdandamudi — Thu, 28 Jul 2016 12:51:22 GMT

Please give a try on the below:

=If(Len(Trim(FIRST_ASSGN_DT')) > 0,'Assigned','UnAssigned')

sunny_talwar — Thu, 28 Jul 2016 12:51:41 GMT

May be like this:

If(Len(Trim(FIRST_ASSGN_DT)) > 0, 'Assigned', 'UnAssigned')

Anonymous — Thu, 28 Jul 2016 13:09:42 GMT

My Unassigned is not showing results in the list box. There are unassigned rows with empty values. So maybe it's blank instead of null? Not sure.

trdandamudi — Thu, 28 Jul 2016 13:12:00 GMT

Can you please post a small sample...

sunny_talwar — Thu, 28 Jul 2016 13:12:47 GMT

I am not 100% sure what you mean. What are you expecting to see?

Anonymous — Thu, 28 Jul 2016 13:21:54 GMT

See attached. I cannot filter on UnAssigned as it's filtered out but in my straight table there are blank/null values.

sunny_talwar — Thu, 28 Jul 2016 13:28:00 GMT

Try adding this to the script:

NULLASVALUE First_Assign_Date;

SET NullValue = ' ';

LOAD id,

First_Assign_Date

FROM

listbox.xlsx

(ooxml, embedded labels, table is test);

and reload and see if it works now