Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loop selected field value and >selected field value in a report and export using macro

Hi All,

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!!.

1 Reply

Hi Krishna,

Please provide us some sample file.