qlik help

[Anonymous]

I have below table

INVOICE NO	PO_NO
123	A
123	D
123
234	B
234
345
456
678	D
678

when I select 123,234,678 then I don't want null value against that invc number if I selecting 345,456 then it should show me null po number for that invc number

Thanks

[alexandros17]

Take a look at this example

[Anonymous]

output is not coming as I want

[alexandros17]

Send me your example document please

[Anonymous]

Hi..

[Anonymous]

any help?

[arulsettu]

try this in listbox

=if(Len(PO_NO)>0,PO_NO)

[sagarkharpude]

=if(IsNull(PO_NO)=-1,'Null',PO_NO)

[Anonymous]

hi sagaer,

where I need to put this expression

[Anonymous]

not working above functions