Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Thanks In Advance
Anil
Now reduction fields are item,store and status ,for next the reduction fileds and values may vary.
For every time we have to change the script before reload.
So i want to reduce the data after reload and qlikview have to identify dynamically the reduction value.
Can you please help on this issue.