topic Date restriiton in QlikView

Date restriiton

smilingjohn — Fri, 20 Nov 2020 18:58:42 GMT

Hi All,

IN oracle db I have a load date of below format in the screenshot .

And when loaded into qlikview the out put date is like the below

Now during loading the data into qlikview I am using this condition

Where Date(Load_Date)>10/31/2020

But still i get the whole data . How can i handle this and load the data aftr 10/OCt/2020 in qlikview .

Thanks in Advance

Re: Date restriiton

MayilVahanan — Thu, 12 Nov 2020 07:23:32 GMT

Hi @smilingjohn
Try like below

Where Floor(Load_Date)> Floor(MakeDate(2020,10,31));

Re: Date restriiton

smilingjohn — Thu, 12 Nov 2020 07:44:47 GMT

Thanks @MayilVahanan

Can you please tell me what does make date do here ?

ANd yes this is working ,if you can please explain me how it is working it would be a good lesson for me for the future .

Re: Date restriiton

MayilVahanan — Thu, 12 Nov 2020 07:49:26 GMT

Hi @smilingjohn

Here, its important is floor() function which convert timestamp to numeric.
MakeDate() function returns a date based on passing year, month & day.