Missing records in Excel.

[Anonymous]

Hi,

While running the report am having  all records(including 1st record) in table box. After exporting to excel the 1^st record is missing .

Thanks,

Krishna.

[sunny_talwar]

I think the record is not missing, somehow the Excel is adding a date to each row. The reason I say this because everything else seems to be captured properly like WeekDay is Monday and StockValue is 4371 in both the screenshots.

[Anonymous]

Hi Sanny,

Thanks for your quick response.

PFA.

Screen shot of table box:

Screen shot of table Excel sheet:

[sunny_talwar]

This is very strange. Would you be able to share your app so that one of us can check exporting it to excel on our computers? (Although I won't be able to open your qvw as I am working with personal edition of QlikView, but I am sure a lot of people will be more than happy to assist you with it.)

HTH

Best,

Sunny

[robert_mika]

Are both of the screenshots from the same data set?

The last column is quite different?

Why are you using year 1900?

Can you add outputs not the shoots?

I can open your qvw if that helps

Feeling Qlikngry?

How To /Missing Manual(18 articles)

[Anonymous]

Hi Robert,

PFA.

Thanks,

Krishna

[qlikviewwizard]

Hi Krishna,

This is may be because of date format used in your application. For me it working fine.

Change: SET DateFormat='DD-MM-YYYY';

[maxgro]

in Qlik date(1) is 31-12-1899

in Excel 1 formatted as date is 01-01-1900

in excel I have 29-02

in Qlik I haven't

it seems that in excel and qlik 61 is 01-03-1900  (DD-MM-YYYY)