Discussion Board for collaboration related to QlikView App Development.
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') = 0AND 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.
Can you please suggest on this
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.