Discussion board where members can get started with QlikView.
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.
Go to Solution.
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
Number of rows - You want to show in chart? If((DateField - Today())<150, DateField)
I had to slightly tweak the query to:
Ready - Today() <=150
remember to check the date format
if the answer is correct, remember to tag it correct and close the thread