Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Quality Analyst

I'm very new to Qlikview, this is my first project.

I'm trying to create an expression to do the following:

I'm trying to count the number of loads that are less than 5 day's from today' date.

(I have three date fields that needs the same code)
my code follows, but doesn't work.

=count({$<[Scheduled Delivery Appt] <=Now()+5 } load_key)

2 Replies
Not applicable
Author

Hi Paul,

Welcome to QV

For your request, try this (assuming that Scheduled Delivery Appt is a date field):

count({$<[Scheduled Delivery Appt] = {"<=$(=Today()+5)"}>} load_key)

Also make sure to load your date fields as numbers then format them the you want on the UI.

For that you can use in your script:

load floor(datefield) as datefield

load num(daystart(datefield)) as datefield

Have a look at this article too Primer for QlikView Date fields

I also recommend you to search for "set analysis" in qlikview help, where you'll find a number of helpful examples to learn set analysis syntax.

You'll also find helpful documents here Resource Library.

Enjoy !

Not applicable
Author

Thank you.