I have a requirement to export report to excel. I found the below link in qlikview community.
VB Macro to Loop (User-Defined) Field and Export (User-Defined) Chart to Excel and Name Sheets by Field Value
But my requirement is not to loop all the values in the selected field. I should control the values in the field.
Example: month field contains jan to dec values and year : 2017,2018.
Now when I select 2017 July, exported excel should contain data from 2017 July to 2018 Dec in each tab in excel.
Thank you in advance for your help!!.