exclude

[raadwiptec]

I want to exclude an  invoice number from the list box as default. but would like to use it when required .. is there a good way?

[ToniKautto]

An alternative to the set expression approach is to simply add an other field to the table, and use this in your presentation. This keeps the front end settings simpler and cleaner.

LOAD
  *,
  if(Not WildMatch(Invoice, '3', '4'),Invoice) AS VisualInvoice
Inline [
Invoice
1
2
3
4
5
];

[chrisg]

Only ONE number? or vary this?

/Christoph

[raadwiptec]

Hi Jason,

but how does it include

[raadwiptec]

hi christoph ..only one number

hi jason,

After flagging this..we are completely excluding..it should be somthing like..one click should be include with in the invoice and another click shoould exclude this from the accounts

[Jason_Michaelides]

Please see attached....

[jmvilaplanap]

I think, the best way is create a table in an CSV file (or an INLINE table) and load it in a MAP in QV Ex:

MAP_EXCLUDE:

Mapping

LOAD

     InvoiceNumber,

     1                    AS Excluded

FROM xxx.csv

And using an ApplyMap in the invoice load you can filter the invoices

Invoices:

LOAD

     *,

     ApplyMap('MAP_EXCLUDE', InvoiceNumber, 0)     AS Exclude

FROM ....

With this solution you can exclude the invoices that you need (not only one or two) in an easy way.

[raadwiptec]

hi jason

this looks good. But the output should be some thing like

If i check Flag  '0'  indeed invoice numbers 1,3,4,5,6,7,8,,9,10  should display

When i check Flag '1' Invoice numbers 1,2,3,4,5,6,7,8,,9,10  should display (not just Invoice number '2')

[raadwiptec]

Hi Jason,

Sorry i just swa the toggle invoices which looks good.. can you tell me .. what is "Show all invoices"? i dont find this dimesnsion anywheere

[Jason_Michaelides]

The toggle "button" is simply a text box I have created. Look at the properties to see how I am generating the text - it's not a dimension. Also look at the Actions tab to see what it's doing.

[raadwiptec]

hi jason .. is there a way to lock this text object at one value ?