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

[arulsettu]

what you are trying to achieve?

if you select invoice it should not show any null values right?

[Anonymous]

no ..

when I select 123,234,678 then I don't want null value against that invc number

and

if I selecting 345,456 then it should show me null po for that invc number

[Anonymous]

when I trying

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

then it will come but not for 123

[sagarkharpude]

Put these expression in expression tab. In dim you will have Invoice number and PO number

[Anonymous]

not coming

[Anonymous]

if I select 123 then I don't want selected red portion

[Anonymous]

Very Sorry to all of you.....

I

I don't want above records.

[sagarkharpude]

try this

=if(GetFieldSelections([INVOICE NO])>0 or IsNull(PO_NO)=0,PO_NO,'Null')

[Anonymous]

123 A

123 D

is not coming.

[sagarkharpude · Accepted solution]

please refer the attached app