Solved: Re: Button - list all transactions where PO# is nu... - Qlik Community

Report Inappropriate Content · ‎2017-03-16

I have a table listing all the fields for my transactions, including the purchase order number (Field = [Purchase Order]).

I want a button that will cause this table to show only the transactions where there is no purchase order number.

What search string do I use? I have searched discussion and manuals and cannot find it -or don't understand what I do find 🙂

THANK YOU!

sunny_talwar · ‎2017-03-16

Create a flag in the script

Trxn:

LOAD [Obj Acct],

[Subsi- diary],

[Account Description],

[G/L Date],

Month,

Amount,

[Purchase Order],

If(Len(Trim([Purchase Order])) = 0, 1, 0) as NullFlag

FROM

[sample_trxn.xlsx]

(ooxml, embedded labels, table is Sheet1);

and then use it like this

sunny_talwar · ‎2017-03-16

May be this

Concat(DISTINCT {<Transactions = {"=Len(Trim([Purchase Order])) = 0"}>} Transactions, '|')

Anonymous · ‎2017-03-16

based on Sunnys approach,use select in field:

='("'&Concat(DISTINCT {<Transactions = {"=Len(Trim([Purchase Order])) = 0"}>} Transactions, '"|"')&'")'

sunny_talwar · ‎2017-03-16

Yes forgot to add those things

Report Inappropriate Content · ‎2017-03-16

I saw those types of strings but thought...it couldn't be that complicated!

Thanks...trying it now.

Report Inappropriate Content · ‎2017-03-16

='("'&Concat(DISTINCT{<Trxn={"=Len(Trim([Purchase Order]))=0"}>}Trxn,'"|"')&'")'

it does not work. It gives me an error after the first <

Trxn is the name of the table (not Transactions)

sunny_talwar · ‎2017-03-16

What are you trying to select here? I mean what field?

Anonymous · ‎2017-03-16

then Trxn isn't a valid field

Report Inappropriate Content · ‎2017-03-16

Trxn is the loaded table - not the Table Object. the Table object is TB04.

sunny_talwar · ‎2017-03-16

Which field are you looking to make selection in using the button?

Button - list all transactions where PO# is null (not there)