Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

madeleine_josef
New Contributor III

Help with date expression

Hello!

I'm trying to limit my data in QS by a date expression in the data load editor.

I would like to limit the data so that it only shows invoices that are past due date today (current date).

The field that set the due date is called: [SupplierInvoiceDueDate]

/ Madeleine

Tags (2)
3 Replies
MVP
MVP

Re: Help with date expression

Add a where clause like this:

Where Num(SupplierInvoiceDueDate) <= Num(Today());

balrajahlawat
Esteemed Contributor

Re: Help with date expression

may be this?

Load

*

from Table

where Date(InvoiceDateField,'DD/MMM/YYYY')<=Date(Today(),'DD/MMM/YYYY')

madeleine_josef
New Contributor III

Re: Help with date expression

Thank you, it worked out really well.