I want to fully automate the process starting from execution of the script to generation of the report. I am successful in implementing the first part through a scheduler. The problem lies in the fact that how am I going to automate the selection process of the columns in the table box format? Presently I manually select the fields and add them on the right hand side under 'Fields Displayed in Tablebox' and click 'Apply' to generate the report. I don't want this process to be manually done.
No the number of columns don't change every time. I am providing an example screenshot of my requirement here
These two fields say 'A' and 'B' are fixed. Each time I run the script, these two fields will appear in the available fields for selection and I need both the fields to generate the report. Now the requirement is that I don't want to click 'Add All>>' and then select 'Apply' tab to generate the table box report. This should be automatically done after the execution of the script so that no manual intervention is required. After this another requirement is that the report generated should be exported to excel.But first of all this selection process has to be automated.
I need this to export the table box to an excel sheet by selecting the 'XL' option present on the top right corner of the table box. I need to automate this step also but unable to achieve it till now. As I am new to Qlikview, I am asking these very basic questions may be but I will be grateful for your help. As I am manually exporting the table box to an excel sheet, I need to create this table box every time I do a reload.