topic Re: Missing records in Excel. in QlikView

Missing records in Excel.

Anonymous — Sat, 10 Oct 2015 04:01:32 GMT

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.

Re: Missing records in Excel.

sunny_talwar — Sat, 10 Oct 2015 04:08:27 GMT

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.

Re: Missing records in Excel.

Anonymous — Sat, 10 Oct 2015 04:42:58 GMT

Hi Sanny,

Thanks for your quick response.

PFA.

Screen shot of table box:

Screen shot of table Excel sheet:

Re: Missing records in Excel.

sunny_talwar — Sat, 10 Oct 2015 04:49:27 GMT

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

Re: Missing records in Excel.

robert_mika — Sat, 10 Oct 2015 04:51:46 GMT

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)

Re: Missing records in Excel.

Anonymous — Sat, 10 Oct 2015 05:18:10 GMT

Hi Robert,

PFA.

Thanks,

Krishna

Re: Missing records in Excel.

qlikviewwizard — Sat, 10 Oct 2015 06:01:39 GMT

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';

Re: Missing records in Excel.

maxgro — Sat, 10 Oct 2015 07:36:57 GMT

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)