topic Re: Generate Excel File using field name as sheet in QlikView

Generate Excel File using field name as sheet

Mon, 24 Apr 2017 20:54:16 GMT

Hi,

I want to create an automatic report in Excel format using a Seller Name as sheet name.

Anyone help my?

Re: Generate Excel File using field name as sheet

Anil_Babu_Samineni — Tue, 25 Apr 2017 01:47:21 GMT

I am not 100 % your need. Would you describe more on this and title seems you need Excel report automatically. By when you want to this after clicking any button or what? And along with Field Name it is possible

Re: Generate Excel File using field name as sheet

rwunderlich — Tue, 25 Apr 2017 01:52:10 GMT

If I understand your question, the field [Name] represents the sheet name. In that case, your code would look something like this:

Employees:

LOAD * INLINE [

ID_Employee, Name

9999, Employe Named 9999

4040, Employee Named 4040

];

FOR i = 1 to FieldValueCount('Name')

LET vSheetName = FieldValue('Name', $(i));

CustomersSales:

LOAD Employee as ID_Employee,

Customer,

Product,

Monday as Sales

FROM

(ooxml, embedded labels, table is $(vSheetName));

NEXT i

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Generate Excel File using field name as sheet

Tue, 25 Apr 2017 12:40:58 GMT

Exactly, the seller name is the field name that i want to use as sheet name.

I will try your answer and tell you if it work.