Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
atsushi_saijo
Creator II
Creator II

Clear and Export to Excel

Dear Gurus, Recently we have encountered a mishap. The QlikView report has been used as a order source of one of the manufacturing plant, and by mistake, user has selected one of the filter and processed the order. User has opened the pivot table, and mistakenly clicked some of the cells, which applied filtering.

To prevent this, we are urget to create a button, in which user can safely click without worrying filtering.

The Report has such option: Clear and Publish.

Error 1.jpg

We simply define actions in the property.

Error 2.jpg

However, creating a button for the excel export (on specific pivot table/object) appears quite hard. I wonder what would be the most simple resolution, avoiding unintended filtering, and safely exporting the excel contents?

Currently what we thought was to make it read only + detached.

Error 4.jpg

I would appreciate for any thoughts on this.

Atsushi

1 Reply
ashfaq_haseeb
Champion III
Champion III

Hi

you can achieve the same by using macro.

look at the attached file.

Regards

ASHFAQ