Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2017-10-02 04:46 PM

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

391 Views
0 Likes
1 Reply
tamilarasu
Champion
Champion
‎2017-10-02 11:52 PM

Hi Krishna,

Please provide us some sample file.

305 Views
0 Likes