topic Re: calender is not working in QlikView

calender is not working

Vinil — Wed, 06 May 2020 20:40:47 GMT

Hi Friends,

I have a logic to pull the last three years monthly QVDs into the script to generate a full QVD so, in that process when my job is completing run on Dec 31st we are getting Dec 30th data but my aim is to fetch the data including Dec 31st when my job runs on Jan 1st, 2020 but it is not happening like that. Here we are getting the data correct in the original QVD.

Below is the attached logic to pull all the monthly QVDs.

Thanks,

Vinil

Re: calender is not working

Vegar — Wed, 06 May 2020 20:54:15 GMT

Hi @Vinil

I think you missed attaching the logic you are using.

BR
Vegar

Re: calender is not working

Vinil — Wed, 06 May 2020 21:00:56 GMT

PFA.

Thanks,

Vinil

Re: calender is not working

Vegar — Wed, 06 May 2020 21:16:38 GMT

I don't see any obvious wrongs in you script. Depending on your content in SMRY_NUM you might want to put single quotes around your variable dollar expansion like this.

WHERE SMRY_NUM >= '$(v_start_period)' AND SMRY_NUM <= '$(v_end_period)'

Re: calender is not working

Vinil — Wed, 06 May 2020 21:23:15 GMT

I did in that manner but no luck.

i would like to try in with the last execution time.

Thanks for your prompt reply.

Thanks,

Vinil