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

[Anonymous]

Hi Sagar,

thanks for quick response...

If I want 345   -

              456  -

then what should I do

[jmmayoral3]

Do you have a row_id in this table?

If you have a row_id it would be much easier.

I am trying to add a calculated field in this table when I load it in the script. this fields is a shwitch that says if row must be printed or not.

But to do this, I need a row_id.

[Anonymous]

I got it

=Aggr(If(Count([INVOICE NO])=1, [INVOICE NO]), [INVOICE NO])

thanks