topic Re: Applymap() in QlikView

Applymap()

Thu, 25 Feb 2016 11:04:58 GMT

Hi to All,

Can we use Apply map() in WHERE condition means while loading data from qvd.

Can please help me out this issue.

Ex: ApplyMap('ExcludedErrorMapping',ERROR_CODE,'IncludeError') <> 'ExcludedError

please give me clarification whether we can use or not.

Regards

Prathap.

Re: Applymap()

tresB — Thu, 25 Feb 2016 11:39:03 GMT

Yes, you can. But I guess, there would be an easier way. Can you post your entire section of code - that shows what exactly you are trying to achieve?

Re: Applymap()

engishfaque — Thu, 25 Feb 2016 11:46:30 GMT

Dear Prathap,

Yes, you can use ApplyMap() in Where Clause.

Here is the way,

ClientTable:

Load

From YourDataSource

Where ApplyMap('Client_Status', Status) = 1

and Match(Country, 'Pakistan');

Kind regards,

Ishfaque Ahmed

Re: Applymap()

avinashelite — Thu, 25 Feb 2016 12:18:11 GMT

Yes, you can use but in your case what your trying to map ?? field name or a value