topic Re: exclude in QlikView

exclude

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: exclude

Chanty4u — Tue, 06 Sep 2016 06:53:46 GMT

did you tried select excluded option in properties?

or may be

=aggr(Only({1-$} FieldName),FieldName).

Re: exclude

Peter_Cammaert — Tue, 06 Sep 2016 06:57:55 GMT

If this will always be the same Invoice Number, you can create a button that sets/resets an include/exclude variable, and create a listbox that either shows all field values or only those that are different from that specific Invoice Number.

While this may be an answer to your question, it won't do much in the remaining part of your document. That Invoice number will still show up in charts and tables. Can you elaborate on why you need this behavior?

Peter

Re: exclude

raadwiptec — Tue, 06 Sep 2016 07:03:00 GMT

hi chanty,

where should this be added?

hi peter.

Yes it is only one invoice number.. i cannot give a you a sample app as it is abig file.. can u give me more details?

Re: exclude

Jason_Michaelides — Tue, 06 Sep 2016 07:08:24 GMT

Do you only want to hide it from the list box or do you want it excluded from all calculations too? I.e. Should Sum(Sales) include or exclude this invoice? If you only want to hide it then you need to use an expression in the list box like the example above, or If(InvoiceNumber<>'xxx',InvoiceNumber).

If you want this invoice excluded from all calcs by default is create a flag field on all invoice numbers where this one is 0 and all others are 1. You can then select/lock/hide this flag field as required.

Hope this helps,

Jason

Re: exclude

Anil_Babu_Samineni — Tue, 06 Sep 2016 07:12:28 GMT

Have you tried this on listbox expression

=If([invoice number],If([invoice number]<> '127448363',[invoice number]))

Re: exclude

tresB — Tue, 06 Sep 2016 07:19:39 GMT

May be like in the attached qvw.

Re: exclude

raadwiptec — Tue, 06 Sep 2016 07:29:23 GMT

hi jason,

yes i like to have as u mentioned.. I want to hide it as default and should be excluded from all calculations ..and for some users i would like to give an option so once they select the invoice gets included and for all calculations also it should be taken into account

can you let me know how to achieve this

Re: exclude

Jason_Michaelides — Tue, 06 Sep 2016 07:57:32 GMT

In the script:

LOAD

<your other fields>...,

If(InvoiceNumber=xxx,1,0) AS %Flag_HideInvoice

FROM....;

In the app, create a button or text box with a Select In Field action. Choose the %Flag_HideInvoice as the field, and as the value put:

If(only(%Flag_HideInvoice)=0,'',0)

This will then toggle between all invoices and the non-hidden ones only.

Hope this helps,

Jason

Re: exclude

Anonymous — Tue, 06 Sep 2016 08:14:17 GMT

Did you try this?

Simply add a expression to your LB instead of field name like this?

If(InvoiceNumber<>'123', InvoiceNumber)

Re: exclude

ToniKautto — Tue, 06 Sep 2016 09:05:10 GMT

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
];

Re: exclude

chrisg — Tue, 06 Sep 2016 09:20:36 GMT

Only ONE number? or vary this?

/Christoph

Re: exclude

raadwiptec — Tue, 06 Sep 2016 09:21:52 GMT

Hi Jason,

but how does it include

Re: exclude

raadwiptec — Tue, 06 Sep 2016 09:28:20 GMT

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

Re: exclude

Jason_Michaelides — Tue, 06 Sep 2016 10:11:29 GMT

Please see attached....

Re: exclude

jmvilaplanap — Tue, 06 Sep 2016 10:24:58 GMT

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.

Re: exclude

raadwiptec — Tue, 06 Sep 2016 10:56:25 GMT

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')

Re: exclude

raadwiptec — Tue, 06 Sep 2016 11:04:18 GMT

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

Re: exclude

Jason_Michaelides — Tue, 06 Sep 2016 11:12:11 GMT

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.

Re: exclude

raadwiptec — Tue, 06 Sep 2016 11:30:04 GMT

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