topic Re: last 150 days in QlikView

last 150 days

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I would like to restrict the number of rows returned to the last 150 days from today(). I can't seem to find any using posts on the forum on how this is done, would be grateful for some assistance.

I require this in the where clause of the load editor.

thanks in advance.

Re: last 150 days

olivierrobin — Tue, 17 Jul 2018 14:23:26 GMT

hello

I suppose you have a date in the data you load

so a where clause like

where CurrentDate-DateLoaded<=150 should work

you have to set CurrentDate to Today's date according to the date formats you treat

Re: last 150 days

Anil_Babu_Samineni — Tue, 17 Jul 2018 14:42:36 GMT

Number of rows - You want to show in chart? If((DateField - Today())<150, DateField)

Re: last 150 days

Anonymous — Tue, 17 Jul 2018 14:47:08 GMT

Thanks Olivier.

I had to slightly tweak the query to:

Ready - Today() <=150

Re: last 150 days

olivierrobin — Tue, 17 Jul 2018 14:50:29 GMT

remember to check the date format

if the answer is correct, remember to tag it correct and close the thread