My requirement is to reduce the data after on post reload.
Reduction data is passed from Excel sheet.
In example you can find the Reduction data in DataToReduce sheets.
There is no restriction for no.of reduction field.
for example :for 1st reload there will be 3 reduction and for next time it may be more or less than 3 fields(Item,Store,Status).
After reload these fields has to identify and remove the fields values already loaded in qlikview memory.
You can see below attached files for reference how to reduce data on post reload.
For Example:On DataToReduction sheet if i add field Item,Store And Status then after reload these fields with that field values had to be reduce in the data model.
But i want the code to be more generic ,so that we can apply for any field and for any field value.
I don't want to use where filters in the script but i am trying to reduce the data after reload.While reload i want full load and after completion of reload ,data reduction has to happen by selecting the loaded reduce data from excel
which has to happen automatically with out selecting the reduce data manually.(By Macro).
As Jagan Said, macro wont works perfectly with AJAX client.
But you have couple options to reduce the data. 1. Publisher reduction 2. Add the data deletion logic to script.
1. First add the Flag to your data model on which fields need to be reduce with excel Input. So the script simply add the Flag to reduction fields. So you can use "Reduce data" option publisher & create new qvw on User documents.
2. In the script add the Flag to execute the specific reduction script like below
Full reload script
SET IsDataReduction = Y ;
IF '$(IsDataReduction) = 'Y' THEN
Logic to reduce the data with inner join from excel file reduction fields.
The script helps you in implementing without using Macros. I am not sure why you are not trying the given script. The script automatically reduces the given values.
If there is any issue in the script let me know, will try another method.
