How to filter a date field in Table

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

Hi All,

I've created a Table chart which contain a field as 'Order Date'. In the expression editor I want to give a condition to load the data only if the Order Date is greater than (today()-30).

Thanks in advance!

Regards,

VVJ

Re: How to filter a date field in Table

VVJ — Thu, 27 Dec 2018 11:51:09 GMT

adding,

I've used below condition and it seems to work.

=if([ORD Creation Date]>=(today()-30),[ORD Creation Date])

topic Re: How to filter a date field in Table in QlikView

How to filter a date field in Table

Re: How to filter a date field in Table