Generate Excel File using field name as sheet

[#1]

Hi,

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

Anyone help my?

[Anil_Babu_Samineni]

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

[rwunderlich]

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

[#4]

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.