topic Re: DATE in QlikView

DATE

Fri, 29 Jan 2016 19:30:29 GMT

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.

Re: DATE

sunny_talwar — Fri, 29 Jan 2016 19:42:22 GMT

Is sheet a field in your application?

Re: DATE

Fri, 29 Jan 2016 19:47:31 GMT

Ex: 1th sheet is 1 st date

2nd sheet is 2nd date

Re: DATE

ziadm — Sun, 31 Jan 2016 01:49:47 GMT

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

];