topic Re: I used the calendar code and missed two days in QlikView

I used the calendar code and missed two days

Sxbbb — Fri, 15 Nov 2024 21:49:42 GMT

I fetch data from excel The latest date is 10/02/2023.

use code

Result

But I use this formula for my calendar.

But the dates 09/02/2023 and 10/02/2023 disappeared

I need E_Date and E_Day data for Listbox.

But the dates 09/02/2023 and 10/02/2023 disappeared

Re: I used the calendar code and missed two days

sidhiq91 — Sat, 11 Feb 2023 04:16:15 GMT

@Sxbbb It is Strange. I don't see any issue why it is getting disappeared. Could you please post the sample date excel. Let me give a try once from my end as well?

Re: I used the calendar code and missed two days

Sxbbb — Sat, 11 Feb 2023 04:28:15 GMT

normally no problem

Date 09/02/2023

 Run through without error