Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Applymap()

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.

3 Replies
tresesco
MVP
MVP

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?

engishfaque
Specialist III
Specialist III

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

avinashelite

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