topic Data Quality Analyst in QlikView

Data Quality Analyst

Wed, 04 Dec 2013 20:55:24 GMT

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)

Thu, 05 Dec 2013 05:59:27 GMT

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 !

Thu, 05 Dec 2013 12:51:07 GMT

Thank you.