Removing applymap from where condition

kishorj1982 — Thu, 07 Mar 2019 10:07:28 GMT

Hi All,

We are using applymap function in where condition in a script and below is the piece of example.

[Sales Order Purchased]:
LOAD DISTINCT [Sales Document Item Key] as [Sales Document Item Key Purchased]
FROM
[SalesOrderMapping.qvd]
(qvd)
WHERE Match ([%Sales doc. type_DOC_TYPE], 'ZQT', 'ZQH') = 0
AND Exists ([Sales Document Item Key]) //AND NOT Exists ([%Sales Document TECO Complete Item], [Sales Document Item Key])
AND ApplyMap ('PO Material Map', [Sales Document Item Key], 'N/A') = %Material_MATERIAL;

But, whenever I am calculating apply map condition sales order mapping file and used the calculated field in where condition results are not matching.

Can you please suggest how to use precalculated apply map condition in where condition comparison.

Thanks

Re: Removing applymap from where condition

kishorj1982 — Fri, 08 Mar 2019 05:15:02 GMT

Hello experts,

Can you please suggest on this

Thanks

Re: Removing applymap from where condition

kishorj1982 — Wed, 20 Mar 2019 07:28:06 GMT

Hello All,

Can you please suggest on this. I need to remove those conditions from where clause but unfortunately after using the calculated column for apply map results are not matching.

Thanks.

topic Re: Removing applymap from where condition in QlikView

Removing applymap from where condition

Re: Removing applymap from where condition

Re: Removing applymap from where condition