topic Macro multiple exclude values in QlikView

Macro multiple exclude values

Wed, 25 Nov 2020 16:16:04 GMT

Hello

Can someone help me to create a macro that will exclude from a field those 3 values

AMS Dealer

EMEA Dealer

APJ Dealer

in this field there is 100 other customer name

thanks

Franck

Re: Macro multiple exclude values

Anil_Babu_Samineni — Tue, 13 Jun 2017 07:30:37 GMT

Why do you need Macros, Macros not good at all. If you want forcibly then you may go ahead. But, I won't recommend you to do

You can achieve by help of Button with search sting

1) Create button and give Title and then create actions

- Select in Field {FieldName and Search String like below -- ("AMS Dealer"|"EMEA Dealer"|"APJ Dealer")}

2) Select Excluded {Give FieldName}

Re: Macro multiple exclude values

Tue, 13 Jun 2017 07:50:32 GMT

HI Thanks

I need to make a macro to paste a lot of graph to an excel, I must change the values in the field using macro

Re: Macro multiple exclude values

marcus_sommer — Tue, 13 Jun 2017 08:05:53 GMT

I suggest to replace/remove those field-values within the script maybe within an extra field like [Customer Name for Export] and to use this within your exporting-task.

- Marcus

Re: Macro multiple exclude values

Tue, 13 Jun 2017 08:57:09 GMT

thanks but I don't understand how I can do this and than run it in the macro?

Re: Macro multiple exclude values

Tue, 13 Jun 2017 09:05:11 GMT

I didn't make this report

but the field that choosing dealer or normal customer is like this

=IF(MarketingCustomerName='AMS Dealer' OR MarketingCustomerName='APJ Dealer' OR MarketingCustomerName= 'EMEA Dealer' , 'Dealers', 'Customers')

This is what you mean?

How I can select only Dealer for this field?

Re: Macro multiple exclude values

Tue, 13 Jun 2017 09:21:09 GMT

Hello

I get it thanks a lot