Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

DATE

Hi  Experts,

I don't have any date field in source files.But i want date field  and if i click on 1st date ,i want field sheet data only.

ex:-  date    sheet

       1/10/15  1

       2/10/15  2............... like this.

any one can help me.

3 Replies
sunny_talwar

Is sheet a field in your application?

Not applicable
Author

Ex: 1th sheet is 1 st date

2nd sheet is 2nd date

ziadm
Specialist
Specialist

if you are loading from multiple sheets then when you load your sheet from excel files take the sheetname such as sheet1 , sheet2 ..ect and load it into a Field name SheetName

LOAD Field1,

     Field2,

     'sheet1' as MyTableName

FROM

[..\sample.xls]

(biff, embedded labels, table is Sheet1$);

You may have to using Mapping Load to map your dates to the sheet if your data of any day does not follow the chronical order

Mapping

LOAD * INLINE [

    DayField, TableName

    1, sheet1

    2, sheet2

    3, sheet2

    4, sheet3

];