topic Re: missing dates while converting String into date in QlikView

missing dates while converting String into date

Anonymous — Tue, 25 Apr 2017 09:45:58 GMT

Hi all,

i have data related to leave forecast for April month.

here date is coming from excel ,here format is String.so i did formatting with Num# .

but here some dates are missing.

how to avoid missing dates issue?

Thanks,

sunny_talwar — Tue, 25 Apr 2017 09:54:27 GMT

Looks right to me... would you be able to share the this file? Leave_Forecast_Apr17

manideep78 — Tue, 25 Apr 2017 09:56:08 GMT

If the format is string and looks like a date field, use date# instead of num#

date(date#(<yourfiled>,'DD-MM-YY'),'DD-MM-YY') as date

this should convert your string type date column to date type date column.

Hope this helps!

Anonymous — Tue, 25 Apr 2017 10:13:14 GMT

In excel file No one applied leaves in 03-Apr-17,04-0-Apr-17 and 10 to 14 days in aplril

but these dates should show in report even though no one applied on those dates..

Thanks,

Anonymous — Tue, 25 Apr 2017 10:40:54 GMT

i created master calendar to generate missing dates.

Working fine now.

Thanks,