Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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 !
Thank you.