How to detect loaded field and values ,data reduction on post reload

[#1]

Hi,

My requirement is initially we load the data from excel. And after for data reduction we load the field and values from xcel and qlikview has to identify the loaded field and value to reduce on post reload.

Ex:-Initially loaded 10 item and to delete items 3,4 and 5.we pass these values from excel and qlikview has to identify automatically these field and values to remove after reload.

Can anyone help on these issue.

Kindly check the attachment.

Thanks,

Anil

[Qrishna]

See attached files.

Input values in the excel sheet called 'Data To be reduced' and save the excel.

reload the application.

[#3]

ok it works...but we want to do reduce data on post reload...

[Qrishna]

ya thats the post reload  only.

[Qrishna]

Oh do you mean, you reload the application, then enter the reduction values in the excel sheet?

Then its not possible with an external file.

if you are making any changes in the external file and the changes be implemented in the app then you have to reload the application.

i have provided you 3 solutions, you can choose one.

According to your requirement the last one is much suitable.

thanks

[#6]

we don't want to change the script..but reduce data on post reload.

like using Onpostreload trigger.

or

Using macro

ActiveDocument.ReduceData function.

[#7]

I am able to reduce the data when we manually selected the field value from the application and able to reduce the data after reload.

But i am facing the problem with how to pass the values dynamically values from Excel and reduce data.

[Qrishna]

you are not changing any script here.

you just input the values/fields to be reduced in the external excel(as you requested) then reload the application.

the data automatically gets reduced.