Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Reduction after On Post Reload.

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

10 Replies
Not applicable
Author

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.