How Can I Get the Time Stamp and Applied Filters Details during Extraction?

[souravrp14]

Dear All,

We are using qlik view application for more than 1 year (Its a fantastic application with nice ETL technology ) and need your expert opinions on one of the concern.

Problem description: Whenever a data is extracted in excel from QV, it doesn't give the applied filters in the excel sheet. As a result, when we go back to the user saying you may have applied wrong filters, my users don't accept it. However, I believe its generic human behavior of not to remember the applied filters during extraction of data.

Now I am looking for some kind of alternative solution which helps me to get the details of what filters have been applied to the report while extraction and the user ID used for extraction and the date and time stamp. This information will help to make the QV given reports more authentic and more AUDIT alined.

Could anyone suggest what can be done in QV for the above problem, so that I can speak to my (developers') colleagues and achieve?

Look forward to hearing your suggestions.

Thanks,

BR,

Sourav Patnaik..

[marcus_sommer]

Within the user-settings in tab export is an option to add the selection-state to the export. I'm actually not sure if there is a similar option within the qmc but if not these setting could be copied into the settings.ini of the server.

But this will only add the selections and not the user or a timestamp. If this is needed it might be better to create an extra textbox/table which will be exported too with each data-export including:

osuer() + now() + getcurrentselections()

- Marcus

[souravrp14]

Will try and get back to you..

BR,

Sourav Patnaik..