Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
kishorj1982
Contributor II

Removing applymap from where condition

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

Tags (2)
2 Replies
kishorj1982
Contributor II

Re: Removing applymap from where condition

Hello experts,

Can you please suggest on this

Thanks

kishorj1982
Contributor II

Re: Removing applymap from where condition

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.