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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
just_me
Contributor
Contributor

Automation + long sheet + tabs

Hi all!

I am creating my first automation. Problem is that one of our sheets contains a table that is so long that it overflows to multiple pages and another contains multiple tabs in a container. My automation works as expected in all other sheets but for the long one it selects only the first "page" and the tabbed one only contains the first tab.

What would be the best option to fix these without having to create new sheets to use in automation?

Thanks in advance

Labels (3)
1 Solution

Accepted Solutions
Patricia_Silva
Specialist II
Specialist II

Hello @just_me, thank you for posting to our Qlik Community. I have internally been asking to our Automations developers and they confirmed it is the way Automation works for now but also suggested the following: 

 

  1. Create several sheets and pull them into the report
  2. Replace the tables with CSV exports (I am attaching an example automation where I used OneDrive to create a CSV file)

Please, let me know if that could help you achieve what you needed 🙂 Thanks a lot!

Help users find answers! Don't forget to mark a correct resolution 🙂

View solution in original post

3 Replies
Patricia_Silva
Specialist II
Specialist II

Hello @just_me, thank you for posting to our Qlik Community. I have internally been asking to our Automations developers and they confirmed it is the way Automation works for now but also suggested the following: 

 

  1. Create several sheets and pull them into the report
  2. Replace the tables with CSV exports (I am attaching an example automation where I used OneDrive to create a CSV file)

Please, let me know if that could help you achieve what you needed 🙂 Thanks a lot!

Help users find answers! Don't forget to mark a correct resolution 🙂
Patricia_Silva
Specialist II
Specialist II

Here attaching the file 🙂

Help users find answers! Don't forget to mark a correct resolution 🙂
just_me
Contributor
Contributor
Author

My automation has several selections that affect the content of the sheets being printed, while 'Get Straight Table Data' brings all the answers without filters to a .csv file. How could I filter the correct rows?